Re: pg_dump is broken in CVS tip

Neil Conway <neilconway@rogers.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