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
Thanks, that works!
On Jul 1, 2010, at 1:34 PM, Kevin Grittner wrote:
> "Jeff Benjamin" 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%'
"Jeff Benjamin" 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 E'w%';
-Kevin
-
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 cann
ola sergatchov 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" line 36 at
> assignme
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 fa
"" 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, yeah. You
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: PQexecP
On Thu, Jul 1, 2010 at 9:00 AM, Bidski wrote:
> "Dave Page" 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 against the dll specifically,
"Dave Page" 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++ -Wl,--enable-auto-import -o
On Wed, Jun 30, 2010 at 11:23 PM, Bidski 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, but when I
> tri
11 matches
Mail list logo
