[BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-17 Thread andrei
The following bug has been logged on the website: Bug reference: 7552 Logged by: Andrei Tchijov Email address: and...@tchijov.com PostgreSQL version: 9.2.0 Operating system: Ubuntu 11.10 Description: In a view (can provide source upon request) where condition on one

[BUGS] Segmentation fault.

2000-08-10 Thread Andrei N.Sobchuck
I've got a MSAccess client application. The application use ODBC to connect to server. Such as in my queries clauses like "some_boolean = TRUE" converts to "some_boolean = 1", I have to create a server procedure: CREATE FUNCTION is_bool_eq_int(BOOL,INT4) RETURNS BOOL AS ' DECLARE sec BOOL; BEGIN

Re: [BUGS] Segmentation fault.

2000-08-14 Thread Andrei N.Sobchuck
> "Andrei N.Sobchuck" <[EMAIL PROTECTED]> writes: > > But one query fails when I use search on boolean field. > > What's the query exactly? I don't see any evidence in your backtrace > that the function is being invoked, so I doubt that has a

[BUGS] BUG #3480: JDBC driver: getIndexInfo() returns quotes around quoted column names

2007-07-23 Thread Andrei Badea
The following bug has been logged online: Bug reference: 3480 Logged by: Andrei Badea Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Debian GNU/Linux testing/lenny, Linux 2.6.17 Description:JDBC driver: getIndexInfo() returns quotes

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
Hi, I have a view (see SQL at the end of this e-mail). Query like following works without any problems on 9.0 and 9.1. select * form v_jobs where rdms_job_number = 41771; However, on 9.2 this query acts as it is select * form v_jobs; It seems that this problem occur only

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
No. But the form for entering bugs is not very ... sophisticated. Thanks for pointing me to this wiki, I will re-submit properly. Cheers, Andrei On Sep 17, 2012, at 11:55 PM, Tom Lane wrote: > and...@tchijov.com writes: >> In a view (can provide source upon reque

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
I will try to provide one, but it will have to wait till weekend. Cheers, Andrei On Sep 18, 2012, at 2:05 PM, Tom Lane wrote: > Andrei Tchijov writes: >> SQL (Please let me know if you need definitions for other tables/views >> involved): > > What we need is