[BUGS] BUG #6079: Wrong select result

2011-06-28 Thread Renat
The following bug has been logged online: Bug reference: 6079 Logged by: Renat Email address: renat.nasy...@itv.ru PostgreSQL version: 9.0.4 Operating system: Windows Description:Wrong select result Details: INPUT: create table foo ( id bigint not null, date_to

Re: [BUGS] BUG #6079: Wrong select result

2011-06-28 Thread Pavel Stehule
Hello It working as expected on 9.0.4 Linux. Please, can you recheck your application? Try to use a console - psql, postgres=# select * from foo where date_to is null and date_to '2011-01-01'; id | date_to +- (0 rows) Regards Pavel Stehule 2011/6/28 Renat renat.nasy...@itv.ru:

Re: [BUGS] BUG #6078: borrar usuario

2011-06-28 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Jun 26, 2011 at 05:27:47AM +, jose javier cabrera centeno wrote: The following bug has been logged online: Bug reference: 6078 Logged by: jose javier cabrera centeno Ésto no es un bug de PostgreSQL. Por eso te sugiero

Re: [BUGS] Ident authentication fails due to bind error on server (8.4.8)

2011-06-28 Thread Marinos Yannikos
On Sat, 18 Jun 2011 04:55:59 +0200, Marinos Yannikos m...@geizhals.at wrote: sysctl -w net.ipv4.tcp_tw_reuse=1 This fixed the issue apparently, so bind() seems to choose ports in TIME_WAIT state for some reason with sin_port=0 and that caused it. Regards, Marinos -- Sent via

Re: [BUGS] BUG #6079: Wrong select result

2011-06-28 Thread Dean Rasheed
2011/6/28 Renat renat.nasy...@itv.ru: create table foo ( id bigint not null, date_to timestamp without time zone, CONSTRAINT foo_pkey PRIMARY KEY (id) ); CREATE INDEX foo_date_to_index  ON foo  USING btree  (date_to) insert into foo (id, date_to) values (1, now()); insert into foo

[BUGS] BUG #6080: information_schema.columns.column_default contains NULL inconsistently

2011-06-28 Thread Chris Bandy
The following bug has been logged online: Bug reference: 6080 Logged by: Chris Bandy Email address: bandy.ch...@gmail.com PostgreSQL version: 9.0.3 Operating system: Gentoo Description:information_schema.columns.column_default contains NULL inconsistently Details: