Opened 18 years ago
Closed 18 years ago
#2711 closed enhancement (fixed)
[PATCH] PostgreSQL schema support
| Reported by: | Owned by: | Christopher Lenz | |
|---|---|---|---|
| Priority: | normal | Milestone: | 0.10 |
| Component: | general | Version: | devel |
| Severity: | normal | Keywords: | |
| Cc: | pacopablo@…, shishz@… | Branch: | |
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
Trac works wonderfully with PostgrwSQL. However, it requires that a separate database be used for each project. With SQLite, this is how things must be, but with PostgreSQL, it becomesa nightmare to manage and just feels nasty.
Attached is a patch against r2771, though it applies cleanly to the latest trunk (r2861).
It is also available on Trac-hacks
Attachments (4)
Change History (11)
by , 18 years ago
| Attachment: | trac-r2771-schema.patch added |
|---|
comment:1 by , 18 years ago
| Cc: | added |
|---|
comment:2 by , 18 years ago
| Version: | 0.9.3 → devel |
|---|
- Updated patch for trunk r2975. It now only touches db/postgres_backend.py.
- Cleaned up code per suggestions from cmlenz
comment:3 by , 18 years ago
Updated patch to apply cleanly to r3026.
No code changes, just line changes
comment:4 by , 18 years ago
| Milestone: | → 0.10 |
|---|---|
| Owner: | changed from to |
| Status: | new → assigned |
by , 18 years ago
| Attachment: | trac-r3248-schema.patch added |
|---|
Updated patch to support PostgreSQL schemas
comment:5 by , 18 years ago
Ok, with the help of cmlenz, I was able to narrow down the changes a little.
The issue turns out to be that the search_path is lost on a rollback(). Because of connection pooling, it appears that there are instances where a connection which has called rollback() get used again. However, the search_path isn't set because a cursor is being reused.
Anyway, the solution in the r3248 patch is to overload rollback() and set the search_path after a rollback happens.
comment:7 by , 18 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Patch applied in [3249]. Thanks!
Patch for schema support in PostgreSQL