Thread

1. pgDump sequence dump bug

   Primoz <primoz@slo-tech.com> — 2001-03-07T16:04:33Z

   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ž
   
   
   

2. Re: pgDump sequence dump bug

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-03-12T23:43:08Z

   "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