Received: from ns1.prima.net.id ([202.57.0.8]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA84873 for ; Thu, 30 Sep 1999 04:06:00 -0400 (EDT) (envelope-from chai@prima.net.id) Received: from prima.net.id (chai@[202.57.0.54]) by ns1.prima.net.id (8.8.4/8.7.2) with ESMTP id IAA08540 for ; Thu, 30 Sep 1999 08:10:08 +0700 (GMT) Sender: chai@ns1.prima.net.id Message-ID: <37F319C6.FA5B5536@prima.net.id> Date: Thu, 30 Sep 1999 15:05:26 +0700 From: Chairudin Sentosa Harjo Reply-To: chai@prima.net.id X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.10 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Constraint Problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Dear Friends, I have a very wierd problem. It should be obvious, but I can't understand why. I am using Postgresql 6.5.2, SuSe 6.2, Pentium III, Kernel Linux 2.2.10. Please notice the error, it keeps saying ck_ngetest_disc_pin, ck_ngetest_disc_country is the cause of the problem. I have inserted the correct value, but why keep giving error??? The wierdest part is, when I insert a value to field "disc_all", the error mentioned "ck_ngetest_disc_pin" !!!.... If the constraint was violated, the error message should be "ck_ngetest_disc_all". create table ngetest ( custnum int8 NOT NULL, first_name varchar(15) NOT NULL, service_type char NOT NULL, sex char NOT NULL, detailed_bill char NOT NULL, ngetest_status char NOT NULL, disc_all char, disc_country char, disc_pin char, constraint pk_ngetest PRIMARY KEY (custnum), constraint ck_ngetest_service_type check (service_type = 'Y' or service_type = 'N' or service_type = 'G' or service_type = 'M' or service_type = 'O' or service_type = 'D'), constraint ck_ngetest_status check (ngetest_status = 'A' or ngetest_status = 'I' or ngetest_status = 'S' or ngetest_status = 'T'), constraint ck_ngetest_disc_all check (disc_all = 'Y' or disc_all = 'N'), constraint ck_ngetest_disc_country check (disc_country = 'Y' or disc_country = 'N'), constraint ck_ngetest_disc_pin check (disc_pin = 'Y' or disc_pin = 'N') ); insert into ngetest (custnum, first_name, service_type, sex, detailed_bill, ngetest_status, disc_all) values (1,'Bob','Y','M','Y','A','Y'); ERROR: ExecAppend: rejected due to CHECK constraint ck_ngetest_disc_pin insert into ngetest (custnum, first_name, service_type, sex, detailed_bill, ngetest_status, disc_country) values (2,'Mike','Y','M','Y','A','Y'); ERROR: ExecAppend: rejected due to CHECK constraint ck_ngetest_disc_pin insert into ngetest (custnum, first_name, service_type, sex, detailed_bill, ngetest_status, disc_pin) values (3,'John','Y','M','Y','A','Y'); ERROR: ExecAppend: rejected due to CHECK constraint ck_ngetest_disc_country Regards, Chairudin Sentosa ************