Tickets :: Comment on [#8082] pgsql create script fails

* Your Email Address
* Spam protection	Enter the letters below: . .. .\ /\ /. . \|\ \|\| \| >< >< \|__\| \| \\|\|__\|/ \/ \\| \|
Comment	> 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. > >
Attachment
Watch this ticket