Re: [BUGS] BUG #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread Craig Ringer
On 13/12/11 08:43, Tom Lane wrote: > Craig Ringer writes: >> because AFAIK there's no ARM asm code or ARM gcc intrinsics hidden away >> in Pg, and that'd be the only other way to get those kinds of errors. > No, you're mistaken about that: we do have inline assembly code in > s_lock.h, and this m

Re: [BUGS] BUG #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread Tom Lane
Craig Ringer writes: > On 12/12/2011 5:09 PM, vbber...@yahoo.com wrote: >> arm-linux-gnueabi-gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith >> -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv >> -I../../../../src/include -D_GNU_SOURCE -c -o xlog.o xlog.c >> /tmp/cclQ

Re: [BUGS] BUG #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread Craig Ringer
On 12/12/2011 5:09 PM, vbber...@yahoo.com wrote: The following bug has been logged on the website: Bug reference: 6331 Logged by: Victor Berdin Email address: vbber...@yahoo.com PostgreSQL version: 8.4.9 Operating system: Linux (Ubuntu/Linaro 4.5.2-8ubuntu4) Description: ar

Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...

2011-12-12 Thread Tom Lane
John Lumby writes: > Sorry about that,   here is a script to demonstrate using a much simpler > example. > It presumes linux and that there is a bash shell at /bin/bash. > You should see table created and loaded (takes a few minutes),   then > successful query explain and run, > then create ind

Re: [BUGS] About Wince App

2011-12-12 Thread Cihan ŞENGÜL
Thank you very much. Sincerely Cihan ŞENGÜL 2011/12/12 Hiroshi Saito > Hi. > > I think, Npgsql regards that it is most suitable for realizing environment > for which you wish as it being an ideal. then, with > C# or VB.NET. though Npgsql is not WinCE environment support. > It may be possible

[BUGS] BUG #6331: Cross compile error/aborts. Works if '--disable-spinlock' is used

2011-12-12 Thread vbberdin
The following bug has been logged on the website: Bug reference: 6331 Logged by: Victor Berdin Email address: vbber...@yahoo.com PostgreSQL version: 8.4.9 Operating system: Linux (Ubuntu/Linaro 4.5.2-8ubuntu4) Description: - Cross Compiler: arm-linux-gnueabi-*(Ubun

Re: [BUGS] About Wince App

2011-12-12 Thread Hiroshi Saito
Hi. I think, Npgsql regards that it is most suitable for realizing environment for which you wish as it being an ideal. then, with C# or VB.NET. though Npgsql is not WinCE environment support. It may be possible if a Npgsql team desires it. Regards, Hiroshi Saito (2011/12/12 5:09), Cihan ŞENG

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-12 Thread Jochen Erwied
Monday, December 12, 2011, 12:33:03 PM you wrote: > On 12.12.2011 13:16, Matteo Beccati wrote: >> Just to clarify, am I correct assuming that the issue does not affect >> tables which have non-indexed inet fields? > Hmm, I think it might also affect queries that do large merge joins on > inet f

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-12 Thread Heikki Linnakangas
On 12.12.2011 13:16, Matteo Beccati wrote: On 12/12/2011 09:29, Heikki Linnakangas wrote: On 12.12.2011 08:26, Tom Lane wrote: Andres Freund writes: In 3b8161723c645853021b57330dd2ea0484ec6131 Heikki made DatumGetInetP unpack toasted values. Unfortunately the btree support functions for the

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-12 Thread Matteo Beccati
Hi Heikki, On 12/12/2011 09:29, Heikki Linnakangas wrote: > On 12.12.2011 08:26, Tom Lane wrote: >> Andres Freund writes: >>> In 3b8161723c645853021b57330dd2ea0484ec6131 Heikki made DatumGetInetP >>> unpack >>> toasted values. Unfortunately the btree support functions for the >>> inet type >>> di

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-12 Thread Heikki Linnakangas
On 12.12.2011 08:26, Tom Lane wrote: Andres Freund writes: In 3b8161723c645853021b57330dd2ea0484ec6131 Heikki made DatumGetInetP unpack toasted values. Unfortunately the btree support functions for the inet type didn't free memory which they have to do in contrast to about everything else. I