From: | Chairudin Sentosa Harjo <chai(at)prima(dot)net(dot)id> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Constraint Problem |
Date: | 1999-09-30 07:24:33 |
Message-ID: | 37F31031.5F50A983@prima.net.id |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Moray McConnachie | 1999-09-30 09:05:08 | Re: [GENERAL] Anyone doing a native NT port? |
Previous Message | Gilles Darold | 1999-09-29 23:26:26 | createdb error |