pg_dump 7.1beta4 misses a table - Mailing list pgsql-bugs

Tara Piorkowski (tara@vilaj.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pg_dump 7.1beta4 misses a table

Long Description
I noticed in attempting to dump a database I was developing that one of the tables failed to get recreated from the
dumpfile. Upon examining the dump file I noticed that there's a placeholder for the table but the actual "create"
commandis missing. All of the other tables in the system were recreated and repopulated without error. 

Below I have included the table definition and also the dump file created by using "pg_dump -t user_profiles tsar",
whichexhibits the same behavior as when the whole database is dumped. 

Note that this database started out as a 7.0.3 database, was successfully dumped, then successfully loaded into pg_dump
7.1beta4.

Here's the system info...

SuSE Linux 6.4 running on a PowerPC (iMac 233/96MB memory)
PostgreSQL 7.1beta4
Compiled using gcc version 2.95.2 19991024 (release)

Thanks for your help on fixing this.

Sample Code
tsar=# \d user_profiles
                                             Table "user_profiles"
        Attribute         |         Type          |                          Modifier
--------------------------+-----------------------+-------------------------------------------------------------
 user_id                  | integer               | not null default nextval('user_profiles_user_id_seq'::text)
 employee_id              | integer               | not null
 first_name               | character varying(25) | not null
 last_name                | character varying(30) | not null
 email_address            | character varying(40) | not null
 timesheet_approver_id    | integer               | not null
 normal_cycle_type_id     | integer               | not null
 normal_start_time        | time                  | not null
 normal_end_time          | time                  | not null
 approver_privileges_flag | boolean               | not null
 admin_privileges_flag    | boolean               | not null
 password                 | character varying(25) | not null
Indices: user_profiles_email_address_und,
         user_profiles_pkey

tsar=# \q
[tara@boreas exports]$ ls -l
total 20
-rw-r-----   1 tara   users       16808 Feb 21 17:24 tsar_20010222.dmp
[tara@boreas exports]$ pg_dump tsar -t user_profiles > tsar_user_profiles_20010222.dmp
[tara@boreas exports]$ cat tsar_user_profiles_20010222.dmp
--
-- Selected TOC Entries:
--
\connect - tara
--
-- TOC Entry ID 2 (OID 73294)
--
-- Name: user_profiles Type: TABLE Owner: tara
--


--
-- Data for TOC Entry ID 4 (OID 73294) TABLE DATA user_profiles
--

-- Disable triggers
UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" ~* 'user_profiles';
COPY "user_profiles"  FROM stdin;
1       6150    Tara    Piorkowski   tara@wildwood.edu     2       1       09:00:00        05:00:00        f       t
 nopass 
2       3640    Gary    Milford gmilford@wildwood.edu   2       1       09:00:00        05:00:00        t       t
nopass
\.
-- Enable triggers
BEGIN TRANSACTION;
CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint);
INSERT INTO "tr" SELECT C."relname", count(T."oid") FROM "pg_class" C, "pg_trigger" T WHERE C."oid" = T."tgrelid" AND
C.
"relname" ~* 'user_profiles'  GROUP BY 1;
UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr" TMP WHERE "pg_class"."relname" =
TMP."tmp_relname"
;
DROP TABLE "tr";
COMMIT TRANSACTION;

--
-- TOC Entry ID 3 (OID 73294)
--
-- Name: "user_profiles_email_address_und" Type: INDEX Owner: tara
--

CREATE UNIQUE INDEX "user_profiles_email_address_und" on "user_profiles" using btree ( "email_address" "varchar_ops" );

--
-- TOC Entry ID 5 (OID 73415)
--
-- Name: "RI_ConstraintTrigger_73414" Type: TRIGGER Owner: tara
--

CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "user_profiles"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR
EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'user_profiles', 'cycle_types', 'UNSPECIFIED',
'normal_cycl
e_type_id', 'cycle_type_id');

--
-- TOC Entry ID 6 (OID 73417)
--
-- Name: "RI_ConstraintTrigger_73416" Type: TRIGGER Owner: tara
--

CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "user_profiles"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW
E
XECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'timesheets', 'user_profiles', 'UNSPECIFIED', 'user_id',
'user_id'
);

--
-- TOC Entry ID 7 (OID 73419)
--
-- Name: "RI_ConstraintTrigger_73418" Type: TRIGGER Owner: tara
--

CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "user_profiles"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW
E
XECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'timesheets', 'user_profiles', 'UNSPECIFIED', 'user_id',
'user_id'
);


No file was uploaded with this report