[Tickets #8082] Re: 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
  Updated By         | Michael Slusarz <slusarz at horde.org>
  Summary            | pgsql create script fails
  Queue              | Horde Base
  Version            | 3.3.3
  Type               | Bug
  State              | Assigned
  Priority           | 2. Medium
  Milestone          |
  Patch              | 1
  Owners             | Horde Developers
------------------------------------------------------------------------------


Michael Slusarz <slusarz at horde.org> (2009-03-17 08:46) wrote:

I have:
Welcome to psql 8.3.6 (server 8.3.5), the PostgreSQL interactive terminal.

> 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".

I don't see this.  The script runs fine for me (although I'm not a  
postgres/SQL expert by any stretch of the imagination).

> 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.

This makes sense.  I have added this part.