| From: | "Jason Lewis" <jlewis(at)lords(dot)com> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | a bug |
| Date: | 2000-01-29 03:13:59 |
| Message-ID: | 001101bf6a06$e5741000$1502000a@zip.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
When I did a pg_dumpall from my 6.4.2 database, it seems to have had
problems with the CONSTRAINTS which then cause problems when reading in to
ver 6.5
this was the offending paragraph
CREATE TABLE "productprice" (
"vendorname" text NOT NULL,
"productid" int4 NOT NULL,
CONSTRAINT ""vendorname does not exist"" CHECK (isvalidvendorname
vendorname )));
Why did it put 2 sets of quotes around the name of the constraint?
Thanks,
Jason
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herr Dumont | 2000-01-30 23:06:48 | "UNIQUE" not recognized when another attribute is declared as "PRIMARY KEY" |
| Previous Message | Herr Dumont | 2000-01-28 23:08:43 | ALTER TABLE / ADD COLUMN BUG |