[Tickets #8082] pgsql create script fails

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8082
------------------------------------------------------------------------------
  Ticket             | 8082
  Created By         | reg at debian.org
  Summary            | pgsql create script fails
  Queue              | Horde Base
  Version            | 3.3.3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


reg at debian.org (2009-03-15 11:45) wrote:

Hi,

I forward you a bug reported by a Debian user  
(http://bugs.debian.org/508571) :

The create.pgsql.sql script fails (running postgresql 8.3.5). After  
creating and switching to the horde database, it fails to create new  
relations with error
"permission denied for schema public".

The script erroneously grants CREATE on the database, which only  
allows creation of new schemas:

GRANT CREATE on DATABASE horde to horde;
\c horde horde;


The script should grant CREATE on the schema:

\c horde
GRANT CREATE ON SCHEMA public TO horde;
SET ROLE horde;

Also, the script should probably run inside a transaction. After the  
script fails, the user is left the horde user and an empty horde  
database.