[BUGS] ISSUE after upgrading to POSTGRES 8.4.8

2013-04-30 Thread Bansal, Pradeep
Hello, I have observed the below issue after upgrading to the above mentioned version of postgress. Any help is very much appreciated:- ISSUE:- === SEQUENCE STATEMENTS = SELECT nextval('"serial1"') PQstatus(m_connection) :-

Re: [BUGS] ISSUE after upgrading to POSTGRES 8.4.8

2013-04-30 Thread Heikki Linnakangas
On 30.04.2013 09:40, Bansal, Pradeep wrote: I have observed the below issue after upgrading to the above mentioned version of postgress. Any help is very much appreciated:- ISSUE:- === SEQUENCE STATEMENTS = SELECT nextval('

Re: [BUGS] ISSUE after upgrading to POSTGRES 8.4.8

2013-04-30 Thread John R Pierce
On 4/29/2013 11:40 PM, Bansal, Pradeep wrote: PQdb name : RAIDSAPROVDB : server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. you need to look at the server log after an error like this, and se

Re: [BUGS] ISSUE after upgrading to POSTGRES 8.4.8

2013-04-30 Thread Bansal, Pradeep
Hi John, Thanks for the reply. If I execute the query directly in the db(not through my program) then this scenario is not at all reproducible. Also with the debug5 mode the logs are:- = Removing lock file (/var/opt/psb/data/STANDALONE_LOCK) DEBUG: received password packet DEBUG:

[BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4

2013-04-30 Thread Adrian . Vondendriesch
The following bug has been logged on the website: Bug reference: 8128 Logged by: Adrian Vondendriesch Email address: adrian.vondendrie...@credativ.de PostgreSQL version: 9.1.9 Operating system: Debian GNU/Linux 7.0 Description: Hi, while browsing on bugs.debian.org I

Re: [BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4

2013-04-30 Thread Adrian Vondendriesch
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Hi, > > while browsing on bugs.debian.org I saw the following bug: > 'pg_upgradecluster fails with "OLD used in query that is not in a > rule"' (http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=688960). > > Because I don't found any reference to

Re: [BUGS] ISSUE after upgrading to POSTGRES 8.4.8

2013-04-30 Thread John R Pierce
On 4/30/2013 2:55 AM, Bansal, Pradeep wrote: Also with the debug5 mode the logs are:- well, I don't see any backend crashes there. -- john r pierce 37N 122W somewhere on the middle of the left coast

Re: [BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4

2013-04-30 Thread Tom Lane
adrian.vondendrie...@credativ.de writes: > [ recent pg_dump fails against an 8.4 server if "old" is used as a name ] Yeah. The reason for this is that "old" was considered a reserved word in 8.4 and before, but since 9.0 it is not reserved (indeed it isn't a keyword at all anymore), so 9.0 and la