Re: [SQL] Is there a bug in PostgreSQL ?

2008-12-11 Thread Pascal Tufenkji
Hello again, Actually I'm using PostgreSQL 8.2.4 By the way, I tried reindexing the tables but the problem remains REINDEX TABLE sip_carriere_dates; REINDEX TABLE sip_carriere; I also made a pg_dump of the database and then restored it in a test one, the queries run perfectly well bu

Re: [SQL] Is there a bug in PostgreSQL ?

2008-12-11 Thread Pascal Tufenkji
I can't, it's an integer column ?! -Original Message- From: Andreas Kraftl [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2008 11:47 AM To: [EMAIL PROTECTED] Subject: Re: [SQL] Is there a bug in PostgreSQL ? Am Donnerstag, den 11.12.2008, 11:33 +0200 schrieb Pascal Tufenkji

Re: [SQL] Is there a bug in PostgreSQL ?

2008-12-11 Thread Tom Lane
"Pascal Tufenkji" <[EMAIL PROTECTED]> writes: > Actually I'm using PostgreSQL 8.2.4 Well, in that case the answer to $SUBJECT is "Yes". Please update to something reasonably current --- at least 8.2.7, which contains the most recent fix for join planning logic according to a quick scan of the CVS