| Lists: | pgsql-bugs |
|---|
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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ž
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Primoz" <primoz(at)slo-tech(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: pgDump sequence dump bug |
| Date: | 2001-03-12 23:43:08 |
| Message-ID: | 7694.984440588@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Primoz" <primoz(at)slo-tech(dot)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