Skip site navigation (1) Skip section navigation (2)

Re: Problem with planer

From: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
To: Eugen(dot)Konkov(at)aldec(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problem with planer
Date: 2008-08-26 10:15:50
Message-ID: 48B3D7D6.3050709@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-bugs
Eugen(dot)Konkov(at)aldec(dot)com wrote:
> select ats.id, ap.value from akh_test_suit ats
> LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
> where ats.ID = 472
> id | value
> 472 | 472
> ID -- integer
> value -- text
> select * from akh_test_suit ats
> LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
> where ats.ID = 472 and ap.value::integer = ats.ID
> ERROR: invalid input syntax for integer: "--username sergeiz 
> --password sergeiz --non-interactive svn://sergeiz"
> akh_properties.values has non numeric values, but those rows do not 
> (MUST NOT) participate in results as showed in first query
> Why PG check them?

can you share the PostgreSQL version you are using with us?
maybe you can compile a test case?
or maybe you are facing some sort of corruption? what happens after dump 
/ reload?

many thanks,

hans

-- 
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql-support.de, www.postgresql-support.com


In response to

Responses

pgsql-bugs by date

Next:From: Eugen.KonkovDate: 2008-08-26 12:36:15
Subject: Re: Problem with planer
Previous:From: Thomas H.Date: 2008-08-26 09:45:09
Subject: Re: BUG #4281: some types of errors do not log statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group