From: | "Patrick Bye (WFF)" <PBYE(at)Westfair(dot)CA> |
---|---|
To: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Problem with 07.03.0100 in ASP.NET page |
Date: | 2003-06-23 20:43:15 |
Message-ID: | FEDC5F156D42DB42BFC805C7D8B15C1E03C49D@wfcal2ks2.westfair.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I just recently upgraded from 7.2.5 to 7.3.0100. The web page that I
written in ASP.NET work fine under 7.2.5 but now that I've upgraded, I get
the following message.
Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints
My table is defined as:
CREATE TABLE pcidxref (
pcid text NOT NULL,
store text NOT NULL,
email text,
CONSTRAINT pcidxref_pkey PRIMARY KEY (pcid)
) WITH OIDS
My select statement is just SELECT pcid, store, email from pcidxref. From
the sounds of the error, I've either got null data or non unique values but
I don't. There's no duplicate key and all fields have data in them. I've
also got no foreign keys. Any suggestions?
Patrick Bye
Programmer / Analyst
Westfair Foods Ltd.
pbye(at)westfair(dot)ca
(403) 291-6538
From | Date | Subject | |
---|---|---|---|
Next Message | Armando Bañuelos | 2003-06-23 22:30:03 | Hi! |
Previous Message | Jeffrey Bohmer | 2003-06-23 17:10:47 | Is psqlodbc driver 7.03.0100 thread safe? |