Home > mailing lists

a bug - Mailing list pgsql-bugs

From	Jason Lewis
Subject	a bug
Date	January 29, 2000 01:11:11
Msg-id	001101bf6a06$e5741000$1502000a@zip.com.au Whole thread Raw
List	pgsql-bugs

Tree view

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

pgsql-bugs by date:

From: hbqlqx@home.net
Date: 28 January 2000, 21:30:08
Subject: xxxscreensavers for you 462 [2/2]

From: "Herr Dumont"
Date: 30 January 2000, 21:14:42
Subject: "UNIQUE" not recognized when another attribute is declared as "PRIMARY KEY"

a bug - Mailing list pgsql-bugs

Previous

Next