[BUGS] BUG #8140: wont start automatically

2013-05-08 Thread workshop
The following bug has been logged on the website: Bug reference: 8140 Logged by: Frank Email address: works...@qualcom.ie PostgreSQL version: 9.2.4 Operating system: Windows 7 64 bit Description: postgres is set to start automatically but wont start - has to be starte

[BUGS] BUG #8141: multi-column check expression evaluating to NULL

2013-05-08 Thread andras . vaczi
The following bug has been logged on the website: Bug reference: 8141 Logged by: Andras Vaczi Email address: andras.va...@zalando.de PostgreSQL version: 9.1.9 Operating system: linux/Ubuntu 12.10 Description: Consider the following table with a CHECK constraint: CREA

Re: [BUGS] BUG #8141: multi-column check expression evaluating to NULL

2013-05-08 Thread Tom Lane
andras.va...@zalando.de writes: > Consider the following table with a CHECK constraint: > CREATE TABLE check_test > ( > id integer NOT NULL, > col integer, > CONSTRAINT unique_with_null_check1 CHECK (col >= 1 AND id < 20) > ); > This INSERT statement succeeds: > INSERT INTO check_test (id,

Re: [BUGS] BUG #8141: multi-column check expression evaluating to NULL

2013-05-08 Thread Gavin Flower
On 09/05/13 01:07, andras.va...@zalando.de wrote: The following bug has been logged on the website: Bug reference: 8141 Logged by: Andras Vaczi Email address: andras.va...@zalando.de PostgreSQL version: 9.1.9 Operating system: linux/Ubuntu 12.10 Description: Consider the fo