Quick Links

unexpected check constraint violation

From:	Jacek Becla <becla(at)slac(dot)stanford(dot)edu>
To:	pgsql-general(at)postgresql(dot)org
Subject:	unexpected check constraint violation
Date:	2009-03-23 19:54:09
Message-ID:	49C7E8E1.4000905@SLAC.Stanford.EDU
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi,

Can someone explain why postgres complains in this case:

create table t(d real, check(d>=0.00603));
insert into t values (0.00603);

ERROR: new row for relation "t" violates check constraint "t_d_check"

thanks
Jacek

Responses

Re: unexpected check constraint violation at 2009-03-23 20:41:06 from Jeremy Harris
Re: unexpected check constraint violation at 2009-03-23 20:49:13 from ries van Twisk
Re: unexpected check constraint violation at 2009-03-23 21:01:20 from Scott Marlowe

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2009-03-23 19:55:13	Re: [SQL] bash & postgres
Previous Message	M L	2009-03-23 19:25:58	Re: The tuple structure of a not-yet-assigned record is indeterminate.