Edwin Grubbs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is.
Short Description pg_dump places GRANT queries before CREATE VIEW Long Description System Configuration --------------------- Architecture (example: Intel Pentium) : AMD Athlon Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.7 ELF PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-7.1.2 Compiler used (example: gcc 2.8.0) : egcs-1.1.2 Please enter a FULL description of your problem: ------------------------------------------------ After a pg_dumpall and restore, all the permissions on all the views were gone. The permissions for all the other tables were fine. Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- createuser nobody createdb test psql test -c 'create view myview as select 1 as val;' psql test -c 'grant all on myview to nobody;' pg_dump test > test.sql createdb test2 psql test2 < test.sql psql test2 -c '\z' This will show no access permissions for myview in the test2 database. If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- At least in the test case, the problem is caused by the GRANT queries being issued before CREATE VIEW; therefore, pg_dump just needs to reorder the queries. Sample Code No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
