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