Roundup Tracker - Issues

Message3699

Author kai
Recipients kai
Date 2009-04-29.11:33:09
Message-id <1241004790.35.0.479777267456.issue2550543@psf.upfronthosting.co.za>
In-reply-to
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.
History
Date User Action Args
2009-04-29 11:33:10kaisetmessageid: <1241004790.35.0.479777267456.issue2550543@psf.upfronthosting.co.za>
2009-04-29 11:33:10kaisetrecipients: + kai
2009-04-29 11:33:10kailinkissue2550543 messages
2009-04-29 11:33:09kaicreate