Re: [BUGS] Possible alpha5 SR bug

2010-04-12 Thread Fujii Masao
Thanks for the test and report! On Tue, Apr 13, 2010 at 1:36 PM, Jeff Davis wrote: > FATAL:  could not load library > "/usr/local/pgsql-9.0alpha5-build1/lib/libpqwalreceiver.so": > dlopen(/usr/local/pgsql-9.0alpha5-build1/lib/libpqwalreceiver.so, 10): > Library not loaded: /usr/local/pgsql/lib

[BUGS] Possible alpha5 SR bug

2010-04-12 Thread Jeff Davis
During the testing day organized a week ago, Quinn Weaver ran into what looks like a problem. I attached the log output at the end of this email. Note that he was running a Mac, but replicating from a Linux machine (both 64-bit). I know this is not a supported configuration, but a segfault seems l

Re: [BUGS] initdb stores default client_encoding from environment-variable

2010-04-12 Thread Craig Ringer
[re-posting as I mistakenly sent this only to the OP] On 09/04/10 16:49, Wolfgang.Koenig wrote: initdb stores default client_encoding from environment-variable Postgres Version: 8.4.3 and 8.3.6 Operating System: Sun Solaris 5.10 and SuseEnterprise 9 When a database is initialized with the ini

[BUGS] BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3

2010-04-12 Thread y.y.chen
The following bug has been logged online: Bug reference: 5414 Logged by: y.y.chen Email address: yyc...@clhs.tyc.edu.tw PostgreSQL version: 8.4.3 Operating system: XP and openSuSE 11.1 Description:pg_dump failure from database 8.4.3 to 8.4.3 Details: pg_dump exe

[BUGS] Reset ACL to default for pg 8.0

2010-04-12 Thread Juan C. Aragon
Hi Guys: I need to know how to reset the ACL to default (null) for a function. This is for PostgreSQL 8.0.14 and 8.4.1 on Windows. I used the User Interface to removed all the Privileges, but the ACL is still = {} I need to make the ACL to be blank (null), nothing in there. Because if th

Re: [BUGS] initdb stores default client_encoding from environment-variable

2010-04-12 Thread Robert Haas
On Fri, Apr 9, 2010 at 4:49 AM, Wolfgang.Koenig wrote: > When a database is initialized with the initdb-command, the default > client_enconding, which will be stored in the DB, depends on the value > of the environment-variable PGCLIENTENCODING at the time of running > initdb. This behaviour is no

[BUGS] Bug in CREATE FUNCTION with character type

2010-04-12 Thread Pavel Golub
Hello, Pgsql-bugs. PostgreSQL version: 8.4.x Operating system: All If RETURNS TABLE clause of CREATE FUNCTION contain column of character type (withou length specifier) it should be treated as character(1) according to manual, but it look like text. (http://www.postgresql.org/docs/8.4/static/d

[BUGS] build error: strlcat/strlcpy used from heimdal libroken.so

2010-04-12 Thread Martin von Gagern
Dear maintainers of PostgreSQL, Build errors for PostgreSQL have been reported on Gentoo Linux, see https://bugs.gentoo.org/285953 for the full bug report there. The issue has originally been reported for PostgreSQL 8.4.1, but has been reproduced with 8.4.2, 8.4.3 and even some 9.0 alpha. In sho