Bug #489: pg_dump places GRANT queries before CREATE VIEW

Edwin Grubbs (egrubbs@rackspace.com) 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