[BUGS] BUG #6376: Cannot prepare a CREATE TABLE statement, error message is unhelpful

2012-01-04 Thread agserm
The following bug has been logged on the website: Bug reference: 6376 Logged by: Ansel Sermersheim Email address: ags...@gmail.com PostgreSQL version: 9.1.2 Operating system: Linux amp; Win32 Description: Attempting to prepare a CREATE TABLE statement fails with a

[BUGS] BUG #6377: some notice on the manual page

2012-01-04 Thread moiseev . igor
The following bug has been logged on the website: Bug reference: 6377 Logged by: Igor Email address: moiseev.i...@gmail.com PostgreSQL version: 8.4.10 Operating system: any Description: On the page of Appendix A. PostgreSQL Error Codes

[BUGS] BUG #6378: exceeding memory usage while creating index in pg-9.1.2

2012-01-04 Thread bock
The following bug has been logged on the website: Bug reference: 6378 Logged by: Julian v. Bock Email address: b...@openit.de PostgreSQL version: 9.1.2 Operating system: Linux x86_64 Description: When creating an index on an inet column the postmaster process tries

Re: [BUGS] BUG #6376: Cannot prepare a CREATE TABLE statement, error message is unhelpful

2012-01-04 Thread Kevin Grittner
ags...@gmail.com wrote: postgres=# prepare foo as create table bar (c integer); ERROR: syntax error at or near create LINE 1: prepare foo as create table bar (c integer); ^ This error message does not in any way indicate that one cannot prepare a create table

Re: [BUGS] BUG #6378: exceeding memory usage while creating index in pg-9.1.2

2012-01-04 Thread anara...@anarazel.de
This has been fixed since 9.1.2. If you browse the history and/or this mailing list you should find a reference. I just have my mobile here, so its a bit too hard to search for a reference Greetings, Andres -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6378: exceeding memory usage while creating index in pg-9.1.2

2012-01-04 Thread Tom Lane
b...@openit.de writes: When creating an index on an inet column the postmaster process tries to allocate much more memory than it should in version 9.1.2. Yeah, a memory leak was accidentally introduced into inet/cidr index operations in 9.1.2. It will be fixed in 9.1.3, or if you're in a

[BUGS] Proble Postgre SQL version 7.4.1

2012-01-04 Thread Patrick PILERI
Bonjour Je rencontre un problème depuis le 3 janvier 2012 sur La base de Données IWSS qui est apparemment corrompu Message Lorsque je veux accéder à la base [root@srv-proxy bin]# ./psql -U sa -d iwss Message = psql: FATAL: could not open relation pg_trigger: Et du coup

[BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread pramsey
The following bug has been logged on the website: Bug reference: 6379 Logged by: Paul Ramsey Email address: pram...@cleverelephant.ca PostgreSQL version: 9.1.2 Operating system: OSX 10.6.8 Description: CREATE OR REPLACE FUNCTION kill_backend() RETURNS VOID AS $$

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread hubert depesz lubaczewski
On Wed, Jan 04, 2012 at 07:17:17PM +, pram...@cleverelephant.ca wrote: The following bug has been logged on the website: Bug reference: 6379 Logged by: Paul Ramsey Email address: pram...@cleverelephant.ca PostgreSQL version: 9.1.2 Operating system: OSX 10.6.8

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Pavel Stehule
Hello I can replicate it postgres=# select kill_backend(); NOTICE: table foo does not exist, skipping CONTEXT: SQL function kill_backend statement 1 The connection to the server was lost. Attempting reset: Failed. ! bash-4.2$ uname -a Linux nemesis 2.6.41.4-1.fc15.x86_64 #1 SMP Tue Nov 29

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Paul Ramsey
One extra detail, my PostgreSQL is compiled with --enable-cassert. This seems to be what sets off the killer function. On Wed, Jan 4, 2012 at 11:25 AM, hubert depesz lubaczewski dep...@depesz.com wrote: On Wed, Jan 04, 2012 at 07:17:17PM +, pram...@cleverelephant.ca wrote: The following bug

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Pavel Stehule
2012/1/4 Paul Ramsey pram...@cleverelephant.ca: One extra detail, my PostgreSQL is compiled with --enable-cassert. This seems to be what sets off the killer function. me too Pavel On Wed, Jan 4, 2012 at 11:25 AM, hubert depesz lubaczewski dep...@depesz.com wrote: On Wed, Jan 04, 2012 at

Re: [BUGS] BUG #5741: syslog line length

2012-01-04 Thread Guillaume Smet
Hi, On Sat, Aug 6, 2011 at 12:18 AM, Noah Misch n...@2ndquadrant.com wrote: A PG_SYSLOG_LIMIT value that loses data to truncation on nearly every default GNU/Linux installation makes for a poor default. On Sat, Aug 6, 2011 at 3:03 AM, Tom Lane t...@sss.pgh.pa.us wrote: OK, applied to HEAD and

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Tom Lane
Paul Ramsey pram...@cleverelephant.ca writes: Further notes, from Andrew (RhodiumToad) on IRC about the cause of this crasher: [12:31pm] RhodiumToad: there's no trivial fix IMO the main bug here is that functions.c isn't expecting qd-dest to be overwritten, so we could work around it by

Re: [BUGS] BUG #6379: SQL Function Causes Back-end Crash

2012-01-04 Thread Tom Lane
I wrote: Perhaps the intoRel stuff should be saving/restoring the original destreceiver instead of just blindly overwriting it. I concluded that was the best fix, and have committed it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)

[BUGS] [PATCH] Prevent hanging on unreachable hosts on startup

2012-01-04 Thread Ryan P. Kelly
The signal handler installed by setup_cancel_handler() will ignore attempts to exit psql should a host be unreachable. Since the functionality it provides won't be used until later, it doesn't make sense to set it up so early. Therefore, move the signal handler closer to where it is first needed.

[BUGS] BUG #6380: dropdb gives error while loading shared libraries: liblber-2.3.so.0

2012-01-04 Thread dean . w . schulze
The following bug has been logged on the website: Bug reference: 6380 Logged by: Dean Schulze Email address: dean.w.schu...@gmail.com PostgreSQL version: 9.1.2 Operating system: CENTOS 6 Description: I've tried both the .rpm from openscg and the .linux.run installer

Re: [BUGS] [PATCH] Prevent hanging on unreachable hosts on startup

2012-01-04 Thread Tom Lane
Ryan P. Kelly rpkell...@gmail.com writes: The signal handler installed by setup_cancel_handler() will ignore attempts to exit psql should a host be unreachable. Hm. That may be worth doing something about, but the proposed patch seems more like a quick-and-dirty hack than a solution. The main

Re: [BUGS] BUG #6380: dropdb gives error while loading shared libraries: liblber-2.3.so.0

2012-01-04 Thread Michael Beattie
Do you have openldap installed? I believe that is a library within that package. Or try custom building postgresql without ldap support. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs