pg_dump and views
От | Marc Mitchell |
---|---|
Тема | pg_dump and views |
Дата | |
Msg-id | 01f201c1d5de$6ba33a80$7501050a@eisolution.com обсуждение исходный текст |
Список | pgsql-admin |
I've run into what I think is a problem with pg_dump. I'm running 7.1.2 under RedHat. I issue a schema-only pg_dump as follows: pg_dump -c -s -S postgres me|gzip> /u0/prod/sql/backups/$YEAR.$MONTH.$DAY.schema.gz Everything seems to run fine. However, upon restore no views were seen. Investigation of the created dump file showed the commands to GRANT were issued before the actual command to create the views in the first place. See the following: -- -- Name: plc_loc_view Type: ACL Owner: -- REVOKE ALL on "plc_loc_view" from PUBLIC; GRANT ALL on "plc_loc_view" to PUBLIC; GRANT ALL on "plc_loc_view" to "me"; -- -- TOC Entry ID 58 (OID 135271) -- -- Name: plc_loc_view Type: VIEW Owner: me -- CREATE VIEW "plc_loc_view" as SELECT plc.plc_uid, plc.plc_type_code, plc.account _nbr, plc.plc_name, plc.address_1, plc.address_2, plc.loc_uid, plc.nd_zipcode, p Is there something here I'm missing. Marc Mitchell Enterprise Information Solutions, Inc. marcm@eisolution.com
В списке pgsql-admin по дате отправления: