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