pgDump sequence dump bug - Mailing list pgsql-bugs

From Primoz
Subject pgDump sequence dump bug
Date
Msg-id 000001c0a720$58ddd920$14a1a8c0@notebook
Whole thread Raw
Responses Re: pgDump sequence dump bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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¾

pgsql-bugs by date:

Previous
From: Mark Stosberg
Date:
Subject: possible mis-handling of nulls in views in 7.0.2
Next
From: Peter Barker
Date:
Subject: referential integrity problem upon deletion and reinsertion