As you can see below it fails on the sequence.
REVOKE ALL ON TABLE gbdetail_gbdetailid_seq FROM PUBLIC;
pg_restore: LOG: statement: GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE
gbdetail_gbdetailid_seq TO jboss;
pg_restore: LOG: statement: --
-- TOC entry 275 (OID 883835)
-- Name: gbequipmentatt; Type: TABLE; Schema: public; Owner: dbdevel
-- Data Pos: 0
--
CREATE TABLE gbequipmentatt (
gbequipmentid bigserial NOT NULL,
equipmentlink1 character varying,
equipmentlink2 character varying
);
pg_restore: NOTICE: CREATE TABLE will create implicit sequence
"gbequipmentatt_gbequipmentid_seq" for "serial" column
"gbequipmentatt.gbequipmentid"
pg_restore: LOG: statement: --
-- TOC entry 276 (OID 883835)
-- Name: gbequipmentatt; Type: ACL; Schema: public; Owner: dbdevel
-- Data Pos: 0
--
REVOKE ALL ON TABLE gbequipmentatt FROM PUBLIC;
pg_restore: LOG: statement: GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE
gbequipmentatt TO jboss;
pg_restore: LOG: statement: --
-- TOC entry 507 (OID 883835)
-- Name: gbequipmentatt_id_seq; Type: ACL; Schema: public; Owner:
dbdevel
-- Data Pos: 0
--
REVOKE ALL ON TABLE gbequipmentatt_id_seq FROM PUBLIC;
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"gbequipmentatt_id_seq" does not exist
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, July 30, 2004 1:35 PM
> To: Jason Tesser
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Backup questions
>
> "Jason Tesser" <JTesser@nbbc.edu> writes:
> > I am not sure how to be more specific.
>
> Could you show us the pg_dump -s (schema only) output?
>
> regards, tom lane
