Skip site navigation (1) Skip section navigation (2)

pgDump sequence dump bug

From: "Primoz" <primoz(at)slo-tech(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: pgDump sequence dump bug
Date: 2001-03-07 16:04:33
Message-ID: 000001c0a720$58ddd920$14a1a8c0@notebook (view raw or flat)
Thread:
Lists: 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┼ż


Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-03-07 18:03:33
Subject: Using libpq to access a repote database from a c trigger function breaks.
Previous:From: Randy HallDate: 2001-03-07 14:33:46
Subject: Re: upgrade 7.0 -> 7.1 using pg_upgrade

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group