[BUGS] BUG #4422: select ... where ... NOT EXISTS / NOT IN

2008-09-17 Thread vasile
The following bug has been logged online: Bug reference: 4422 Logged by: vasile Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Centos 4 Description:select ... where ... NOT EXISTS / NOT IN Details: I have this 2 similar queries. Why

[BUGS] BUG #4421: convert_to() should be immutable

2008-09-17 Thread
The following bug has been logged online: Bug reference: 4421 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Description:convert_to() should be immutable Details: The function convert_to(string text, dest_encoding name

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-17 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: PostgreSQL version: 8.3.3 Operating system: Linux Description:convert_to() should be immutable Details: The function convert_to(string text, dest_encoding name) is not allowed to be used in a index expression, because it is not marked as "IMMUTABLE". Accordin

Re: [BUGS] BUG #4422: select ... where ... NOT EXISTS / NOT IN

2008-09-17 Thread hubert depesz lubaczewski
On Wed, Sep 17, 2008 at 02:53:51PM +, vasile wrote: > I have this 2 similar queries. > > Why the 1st query is returning 1000+ rows and the 2nd one no rows ? > The col1 is not empty in both tables. there is no bug. check this: http://www.depesz.com/index.php/2008/08/13/nulls-vs-not-in/

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-17 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> The function convert_to(string text, dest_encoding name) is not allowed to >> be used in a index expression, because it is not marked as "IMMUTABLE". > You can change the way a conversion is done with CREATE/DROP CONVERSI

[BUGS] 0x1A in control file on Windows

2008-09-17 Thread ITAGAKI Takahiro
I found a bug that pg_controldata ends with error if control files contain 0x1A (Ctrl+Z) on Windows. We probably need to add PG_BINARY when we open control files because 0x1A is an end-of-file marker on Windows. This fix needs to be applied in back versions (8.2, 8.3 and HEAD). Index: src/bin/pg

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-17 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > I found a bug that pg_controldata ends with error if control files > contain 0x1A (Ctrl+Z) on Windows. > We probably need to add PG_BINARY when we open control files > because 0x1A is an end-of-file marker on Windows. Well, why is that a bug? If the

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-17 Thread ITAGAKI Takahiro
Tom Lane <[EMAIL PROTECTED]> wrote: > ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > > We probably need to add PG_BINARY when we open control files > > because 0x1A is an end-of-file marker on Windows. > > Well, why is that a bug? If the platform is so silly as to define text > files that way,