Issue 2550543
Created on 2009-04-29 11:33 by kai, last changed 2011-07-01 15:05 by ber.
File name |
Uploaded |
Description |
Edit |
Remove |
roundup.patch
|
kai,
2009-04-29 11:33
|
Support postgresql 8.3 and up |
|
|
msg3699 |
Author: [hidden] (kai) |
Date: 2009-04-29 11:33 |
|
Using roundup with postgresql 8.3 the initialise command fails with the error:
roundup.hyperdb.DatabaseError: FATAL: permission denied for database "template1"
DETAIL: User does not have CONNECT privilege.
PostgreSQL introduced a database named "postgres" in version 8.1:
> In prior releases, template1 was used both as a default connection
> for utilities like createuser, and as a template for new databases.
> This caused CREATE DATABASE to sometimes fail, because a new database
> cannot be created if anyone else is in the template database. With this
> change, the default connection database is now postgres, meaning it is much
> less likely someone will be using template1 during CREATE DATABASE.
My proposed patch should support 8.3, reverting to old style behaviour incase the database
named 'postgres' does not exist.
On another note: The code to send a databasecommand (db_command) actually contains
some comments indicating that an error could be expected. I'd love to know if the author of
that piece programmed that because of the locking issue mentioned above.
|
msg4318 |
Author: [hidden] (ber) |
Date: 2011-07-01 15:05 |
|
Thanks for the patch and the description, commited now
with Rev4626.
|
|
Date |
User |
Action |
Args |
2011-07-01 15:05:34 | ber | set | status: new -> closed resolution: fixed messages:
+ msg4318 nosy:
+ ber |
2009-04-29 11:33:10 | kai | create | |
|