Re: pgDump sequence dump bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pgDump sequence dump bug
Date
Msg-id 7694.984440588@sss.pgh.pa.us
Whole thread Raw
In response to pgDump sequence dump bug  ("Primoz" <primoz@slo-tech.com>)
List pgsql-bugs
"Primoz" <primoz@slo-tech.com> writes:
> 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),
> );

This is fixed in 7.1.  I don't think there's any simple fix possible
in earlier versions.  I suggest you avoid mixed-case sequence names
for the moment...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: referential integrity problem upon deletion and reinsertion
Next
From: Tom Lane
Date:
Subject: Re: possible mis-handling of nulls in views in 7.0.2