Re: pg_dump is broken in CVS tip

Neil Conway <neilconway(at)rogers(dot)com> writes:
> However, when I created a table using the commands above and then
> dumped it again, I got a dump that worked properly:
> ...
> If you can give me a reproduceable test-case, I'll fix the bug.

Sigh ... I should take my own advice about checking that I've described
a problem completely :-(. It looks like you also need a foreign-key
reference to the table. This will generate the problem:

create table t1 (f1 int primary key);

create table t2 (f1 int references t1);

The dump of t1 will now read

CREATE TABLE "t1" (
"f1" integer NOT NULL,
Constraint "t1_pkey" Primary Key ("f1")
);

Sorry for the inadequate report.

regards, tom lane