Problem with 07.03.0100 in ASP.NET page

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

Browse pgsql-odbc by date

  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?