Re: [GENERAL] unexpected check constraint violation

2009-03-23 Thread Jacek Becla
Thanks Ries. Do you know if that is a postgres feature or a bug? In practice, I wanted to load the data from a file using COPY FROM. Modifying a large csv file in impractical and not very elegant. thanks, Jacek ries van Twisk wrote: On Mar 23, 2009, at 2:54 PM, Jacek Becla wrote: Hi

[GENERAL] unexpected check constraint violation

2009-03-23 Thread Jacek Becla
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To