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

2011-06-15 Thread Tom Lane
"Sebastian" 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 crashes with > fo

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; root:xnu-1504

[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 #6061: Progresql.exe memory usage using HOLD cursor.

2011-06-15 Thread Tom Lane
"Yann" 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 *tuple), USEMEM

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

2011-06-15 Thread Tom Lane
"Shigehiro honda" 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 zlib.h and it does o

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

2011-06-15 Thread Tom Lane
Joel Jacobson 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 not permitted

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

2011-06-15 Thread Tom Lane
Gary Wong 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 /usr/local/pgs

[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 POSTGRESQ

[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 -z

[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