I think there is a bug in pgDump..

If I try to dump database with sequences which have "Uppercase" names it
dumps it like this:
CREATE SEQUENCE "Uppercase";
CREATE TABLE "Table" (
  "ID" int4 not null default nextval('Uppercase':something),
);

And it do not work until I manualy change it to

CREATE SEQUENCE "Uppercase";
CREATE TABLE "Table" (
  "ID" int4 not null default nextval('"Uppercase"':something),
);

If it is not a bug please tell me how to make pgdump working in a way that
restoration of database will be possible without manual changes to backup.

Primož


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to