pg_dump and views

From: "Marc Mitchell" <marcm(at)eisolution(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump and views
Date: 2002-03-27 22:26:15
Message-ID: 01f201c1d5de$6ba33a80$7501050a@eisolution.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)eisolution(dot)com

Browse pgsql-admin by date

  From Date Subject
Next Message Andre Schubert 2002-03-28 08:06:55 Last_Inserted Value
Previous Message Richard Emberson 2002-03-27 18:06:00 ERROR: plpgsql: cache lookup for proc 17911 failed