Re: [BUGS] Libpq.dll: File not recognized

2010-07-01 Thread Dave Page
On Wed, Jun 30, 2010 at 11:23 PM, Bidski bid...@bigpond.net.au wrote: Hi all, I downloaded the one-click installer for PostgreSQL 9.0 beta2 for Windows x64 (postgresql-9.0.0-beta2-windows-x64.exe) and installed it on my Windows 7 64 bit system. Installation seemed to go off without a hitch,

Re: [BUGS] Libpq.dll: File not recognized

2010-07-01 Thread Bidski
Dave Page dp...@pgadmin.org writes: Don't link against the DLL, link against the .lib. Isnt the .lib the static library and the dll the shared library? And Im not linking against the dll specifically, that is the library that g++ is wanting to link to. My link command is g++

Re: [BUGS] Libpq.dll: File not recognized

2010-07-01 Thread Dave Page
On Thu, Jul 1, 2010 at 9:00 AM, Bidski bid...@bigpond.net.au wrote: Dave Page dp...@pgadmin.org writes: Don't link against the DLL, link against the .lib. Isnt the .lib the static library and the dll the shared library? No, it should be the import library for the DLL. And Im not linking

[BUGS] BUG #5533: PQexecParams in Binary Mode returns incorrect value for float4

2010-07-01 Thread
The following bug has been logged online: Bug reference: 5533 Logged by: Email address: myk...@gmail.com PostgreSQL version: 8.4.3 Operating system: Ubuntu 10.04 Description:PQexecParams in Binary Mode returns incorrect value for float4 Details: Experience:

Re: [BUGS] BUG #5533: PQexecParams in Binary Mode returns incorrect value for float4

2010-07-01 Thread Tom Lane
myk...@gmail.com writes: Some needless speculation: 0.75 = 3F40 (as IEEE 32-bit float) 0.75 = 3FE8 (as IEEE 64-bit float) 1.812500 = 3FE8 (as returned by PQexecParams) i.e. the return value is the first 32-bits of the 64-bit representation of the correct value. Well,

[BUGS] BUG #5534: IS DOCUMENT predicate errors instead of returning false

2010-07-01 Thread Mike Fowler
The following bug has been logged online: Bug reference: 5534 Logged by: Mike Fowler Email address: m...@mlfowler.com PostgreSQL version: 9.0beta2 Operating system: Linux 2.6.31-14-generic #48-Ubuntu SMP Description:IS DOCUMENT predicate errors instead of returning

Re: [BUGS] BUG #5531: REGEXP_ REPLACE causes connection drop

2010-07-01 Thread Tom Lane
ola sergatchov ola_sergatc...@hotmail.com writes: Here is the copy from postgresql log from June 23: ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used ERROR: out of memory DETAIL: Failed on request of size 251049. CONTEXT: PL/pgSQL function composite_statements_as_set

[BUGS] BUG #5535: Backslash in condition for LIKE statement is not seen

2010-07-01 Thread Jeff Benjamin
The following bug has been logged online: Bug reference: 5535 Logged by: Jeff Benjamin Email address: j...@ivertex.com PostgreSQL version: 8.3.8 Operating system: MacOSX, Linux Description:Backslash in condition for LIKE statement is not seen Details: Seems one

Re: [BUGS] BUG #5535: Backslash in condition for LIKE statement is not seen

2010-07-01 Thread Kevin Grittner
Jeff Benjamin j...@ivertex.com wrote: Seems one cannot use a backslash character in a LIKE condition. By default that has special meaning as an escape character. Try this: select * from test where pattern like E'\\w%' escape '#'; or this: select * from test where pattern like

Re: [BUGS] BUG #5535: Backslash in condition for LIKE statement is not seen

2010-07-01 Thread Jeff Benjamin
Thanks, that works! On Jul 1, 2010, at 1:34 PM, Kevin Grittner wrote: Jeff Benjamin j...@ivertex.com wrote: Seems one cannot use a backslash character in a LIKE condition. By default that has special meaning as an escape character. Try this: select * from test where pattern like

Re: [BUGS] BUG #5531: REGEXP_ REPLACE causes connection drop

2010-07-01 Thread ola sergatchov
Sure. Here is the copy from postgresql log from June 23: ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used ERROR: out of memory DETAIL: Failed on request of size 251049. CONTEXT: PL/pgSQL function composite_statements_as_set line 36 at assignment SQL function