Roundup Tracker - Issues

Issue 2550543

classification
PostgreSQL versions 8.3 support
Type: Severity: normal
Components: Database Versions: 1.4
process
Status: closed fixed
:
: : ber, kai
Priority: : patch

Created on 2009-04-29 11:33 by kai, last changed 2011-07-01 15:05 by ber.

Files
File name Uploaded Description Edit Remove
roundup.patch kai, 2009-04-29 11:33 Support postgresql 8.3 and up
Messages
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.
History
Date User Action Args
2011-07-01 15:05:34bersetstatus: new -> closed
resolution: fixed
messages: + msg4318
nosy: + ber
2009-04-29 11:33:10kaicreate