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