Re: [BUGS] abnormal behaviour of a CHECK CONSTRAINT with a regular

2004-02-11 Thread Daniel Struck
the user only provides the year, the date is inserted as 16.05.year,...). Kind regards, Daniel Struck -- Retrovirology Laboratory Luxembourg Centre Hospitalier de Luxembourg 4, rue E. Barblé L-1210 Luxembourg phone: +352-44116105 fax: +352-44116113 web: http://

[BUGS] abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added

2004-05-16 Thread Daniel Struck
11.1999" CONTEXT: PL/pgSQL function "function_test_reg1" line 8 at assignment retrovirology=# INSERT INTO test_reg1 (date_user) VALUES ('11:1999'); ERROR: invalid input syntax for type date: "15.11:1999" CONTEXT: PL/pgSQL function "function_test_reg1" l

Re: [BUGS] abnormal behaviour of a CHECK CONSTRAINT with a regular

2004-05-17 Thread Daniel Struck
> I don't see any bug here; it's just that CHECK constraints are applied > after any BEFORE triggers are run. Since the triggers could change the > data to be inserted, the reverse order would be insecure. Ups, it did make some false assumptions. Thank you for the clarification. If I understo