[BUGS] Expected regression test difference on Mac OSX...

2004-02-10 Thread Sean Chittenden
FYI, the regression tests on OS-X 10.3 aren't quite correct (formatting of -0). Not sure how to address this, but thought I'd point it out to the interested parties. -sc Darwin suxunil.local 7.2.0 Darwin Kernel Version 7.2.0: Thu Dec 11 16:20:23 PST 2003; root:xnu/xnu-517.3.7.obj~1/RELEASE_PP

Re: [BUGS] Expected regression test difference on Mac OSX...

2004-02-10 Thread John Siracusa
On 2/10/04 3:54 AM, Sean Chittenden wrote: > FYI, the regression tests on OS-X 10.3 aren't quite correct (formatting > of -0). Not sure how to address this, but thought I'd point it out to > the interested parties. -sc > > Darwin suxunil.local 7.2.0 Darwin Kernel Version 7.2.0: Thu Dec 11 > 16:2

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

2004-02-10 Thread Tom Lane
Daniel Struck <[EMAIL PROTECTED]> writes: > I think I have found a bug in postgresql: 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.

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

2004-02-10 Thread Tom Lane
Daniel Struck <[EMAIL PROTECTED]> writes: > This makes it also impossible to change the type of a value by a trigger? Correct. It is annoying in some cases, but if the input to the trigger isn't of the column datatype, then what type is it? It's hard to see how that could work in general. If yo

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

2004-02-10 Thread Stephan Szabo
On Tue, 10 Feb 2004, Daniel Struck wrote: > retrovirology=# INSERT INTO test_reg1 (date_user) VALUES ('111.1999'); > ERROR: invalid input syntax for type date: "111.1999" > CONTEXT: PL/pgSQL function "function_test_reg1" line 8 at assignment > retrovirology=# INSERT INTO test_reg1 (date_user) VA

[BUGS] BUG #1077: install-strip does not work for MacOS X 10.2.8

2004-02-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1077 Logged by: Andrew MacRae Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: MacOS X 10.2.8 Description:install-strip does not work for MacOS X 10.2.8 Details: MacOS X 10.