[BUGS] Postgresql 9.0.4 initdb bug on solaris 64 bit

2011-06-15 Thread Gary Wong
Hi, I'm trying to install Postgresql 9.0.4 on solaris but ran into problems when trying to run the initdb command under the postgres Unix account. [Server OS Version] Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC Copyright (c) 2010, Oracle and/or its affiliates. All rights

[BUGS] BUG #6060: does not work -z option of pg_basebackup

2011-06-15 Thread Shigehiro honda
The following bug has been logged online: Bug reference: 6060 Logged by: Shigehiro honda Email address: fwif0...@mb.infoweb.ne.jp PostgreSQL version: 9.1 beta2 Operating system: Linux Description:does not work -z option of pg_basebackup Details: it seems that the

[BUGS] BUG #6061: Progresql.exe memory usage using HOLD cursor.

2011-06-15 Thread Yann
The following bug has been logged online: Bug reference: 6061 Logged by: Yann Email address: yann.delo...@esker.fr PostgreSQL version: 9.0.4 Operating system: Windows 2008 R2 Description:Progresql.exe memory usage using HOLD cursor. Details: Hello, I use

Re: [BUGS] Postgresql 9.0.4 initdb bug on solaris 64 bit

2011-06-15 Thread Tom Lane
Gary Wong gary_w...@dot.ca.gov writes: [Environment under in the postgres account] $ env LC_MONETARY=en_US.ISO8859-15 LC_TIME=en_US.ISO8859-15 LC_MESSAGES=C LC_CTYPE=en_US.ISO8859-1 LC_COLLATE=en_US.ISO8859-15 LC_NUMERIC=en_US.ISO8859-15 [Message I get when I run initdb] $ initdb -D

Re: [BUGS] [GENERAL] psql \s not working - OS X

2011-06-15 Thread Tom Lane
Joel Jacobson j...@gluefinance.com writes: I'm trying the new 9.1b2 release and got a weird problem with the \s command to show the latest history, for some reason it's trying to write to /dev/tty instead of printing out to stdout: glue=# \s could not save history to file /dev/tty: Operation

Re: [BUGS] BUG #6060: does not work -z option of pg_basebackup

2011-06-15 Thread Tom Lane
Shigehiro honda fwif0...@mb.infoweb.ne.jp writes: it seems that the -z option of pg_basebackup does not work correctly. In getopt_long() function, there is not 'z' in 3rd argument. Ooops. Doesn't look like this got tested much (or at all). And Z_DEFAULT_COMPRESSION are defined as (-1) in my

Re: [BUGS] BUG #6061: Progresql.exe memory usage using HOLD cursor.

2011-06-15 Thread Tom Lane
Yann yann.delo...@esker.fr writes: The issue is that in this case all rows are store in memory instead of file in the process postgresql.exe I think the issue is in the file tuplestore.c. When a tuple is added the function static void tuplestore_puttuple_common(Tuplestorestate *state, void

[BUGS] BUG #6062: psql terminates on auto-complete

2011-06-15 Thread Sebastian
The following bug has been logged online: Bug reference: 6062 Logged by: Sebastian Email address: skursch...@gmail.com PostgreSQL version: 9.0.1 Operating system: Darwin Kernel Version 10.7.0: Sat Jan 29 15:17:16 PST 2011; root:xnu-1504.9.37~1/RELEASE_I386 i386 Description:

Re: [BUGS] BUG #6062: psql terminates on auto-complete

2011-06-15 Thread John R Pierce
On 06/15/11 12:22 PM, Sebastian wrote: The following bug has been logged online: Bug reference: 6062 Logged by: Sebastian Email address: skursch...@gmail.com PostgreSQL version: 9.0.1 Operating system: Darwin Kernel Version 10.7.0: Sat Jan 29 15:17:16 PST 2011;

Re: [BUGS] BUG #6062: psql terminates on auto-complete

2011-06-15 Thread Tom Lane
Sebastian skursch...@gmail.com writes: Operating system: Darwin Kernel Version 10.7.0: Sat Jan 29 15:17:16 PST 2011; root:xnu-1504.9.37~1/RELEASE_I386 i386 When using the auto-complete function (TAB) to complete the name of a particular set of tables when writing a SELECT statement, psql