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

a bug

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Herr DumontDate: 2000-01-30 23:06:48
Subject: "UNIQUE" not recognized when another attribute is declared as "PRIMARY KEY"
Previous:From: Herr DumontDate: 2000-01-28 23:08:43
Subject: ALTER TABLE / ADD COLUMN BUG

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