[BUGS] BUG #6759: configure script fails to detect xlc compiler version

2012-07-25 Thread jez . wain
The following bug has been logged on the website: Bug reference: 6759 Logged by: jez wain Email address: jez.w...@bull.net PostgreSQL version: 9.1.4 Operating system: AIX 7.1 Description: The configure script (near line 3247) detects the compiler version with --vers

[BUGS] BUG #6761: unexpected behaviour of 'now'::timestamp

2012-07-25 Thread bert
The following bug has been logged on the website: Bug reference: 6761 Logged by: Bert Thomas Email address: b...@brothom.nl PostgreSQL version: 9.1.3 Operating system: Linux Description: Hi, To reproduce what I mean, consider this function: CREATE FUNCTION testbug()

[BUGS] BUG #6756: primary_conninfo is ignored if restore_command is set..

2012-07-25 Thread ghazel
The following bug has been logged on the website: Bug reference: 6756 Logged by: Greg Hazel Email address: gha...@gmail.com PostgreSQL version: 9.1.4 Operating system: Amazon Linux Description: Trying to get a slave to stream updates from a master, I had both: restor

[BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-07-25 Thread jez . wain
The following bug has been logged on the website: Bug reference: 6758 Logged by: jez wain Email address: jez.w...@bull.net PostgreSQL version: 9.1.4 Operating system: AIX 7.1 Description: Building Postgresql on AIX7.1 with IBM's xlc compiler I got an undefined symbol

[BUGS] BUG #6760: make check fails on strings SQL T581 regex test

2012-07-25 Thread jez . wain
The following bug has been logged on the website: Bug reference: 6760 Logged by: jez wain Email address: jez.w...@bull.net PostgreSQL version: 9.1.4 Operating system: AIX 7.1 Description: I built 9.1.4 from sources using the following configure command: LDFLAGS="-L/u

Re: [BUGS] BUG #6756: primary_conninfo is ignored if restore_command is set..

2012-07-25 Thread Fujii Masao
On Wed, Jul 25, 2012 at 10:42 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 6756 > Logged by: Greg Hazel > Email address: gha...@gmail.com > PostgreSQL version: 9.1.4 > Operating system: Amazon Linux > Description: > > Trying to get a slave

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-07-25 Thread Alvaro Herrera
Excerpts from jez.wain's message of mié jul 25 05:49:35 -0400 2012: > ld: 0711-317 ERROR: Undefined symbol: .mbstowcs_l > ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more > information. > > AIX7 supports the mbstowcs API but not mbstowcs_l. In > src/include/pg_config.h I commen

Re: [BUGS] BUG #6761: unexpected behaviour of 'now'::timestamp

2012-07-25 Thread Pavel Stehule
Hello this is not bug - it is consequence of plan cache http://postgres.cz/wiki/Automatic_execution_plan_caching_in_PL/pgSQL please, use CURRENT_TIMESTAMP instead - using 'now'::timestamp is deprecated due this issue Regards Pavel 2012/7/25 : > The following bug has been logged on the websit

Re: [BUGS] BUG #6761: unexpected behaviour of 'now'::timestamp

2012-07-25 Thread Tom Lane
Pavel Stehule writes: > this is not bug - it is consequence of plan cache FWIW, there is documentation of this issue near the end of http://www.postgresql.org/docs/9.1/static/plpgsql-implementation.html#PLPGSQL-PLAN-CACHING This exact case isn't covered in the examples, but the point is that the

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-07-25 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from jez.wain's message of mié jul 25 05:49:35 -0400 2012: >> AIX7 supports the mbstowcs API but not mbstowcs_l. In >> src/include/pg_config.h I commented out the define for HAVE_WCSTOMBS_L 1, >> recompiled src/backend/utils/adt/pg_locale.c and the build complet

Re: [BUGS] BUG #6760: make check fails on strings SQL T581 regex test

2012-07-25 Thread Tom Lane
jez.w...@bull.net writes: > *** > *** 347,354 >three | f1 | exp_ln_f1 > ---+--+--- > | 1004.3 |1004.3 > !| 1.2345678901234e+200 | 1.23456789012338e+200 >

Re: [BUGS] BUG #6759: configure script fails to detect xlc compiler version

2012-07-25 Thread Peter Eisentraut
On ons, 2012-07-25 at 10:08 +, jez.w...@bull.net wrote: > When faced with a flag it doesn't recognize, xlc prints the man page. > Thus the --version, -v, -V tests result in a particularly large > config.log file And is this an actual problem? The code you are referring to is automatically ge

Re: [BUGS] BUG #6761: unexpected behaviour of 'now'::timestamp

2012-07-25 Thread Bert Thomas
Thanks Tom and Pavel! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-25 Thread karavelov
The following bug has been logged on the website: Bug reference: 6763 Logged by: Luben Karavelov Email address: karave...@mail.bg PostgreSQL version: 9.1.4 Operating system: Debian Linux Description: I was trying to migrate a big ER table (user preferences) into a new

Re: [BUGS] BUG #6763: Severe memory leak with arrays and hstore

2012-07-25 Thread Tom Lane
karave...@mail.bg writes: > The query I have tried to use is: > INSERT INTO preferences > SELECT user_id,hstore(array_agg(name), array_agg(value)) > FROM old_prefs > GROUP BY user_id; > But the postgres backend consumed all the available memory (6G free + 4G > swap) and finally was killed by t