X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C1691D1E7EF for ; Tue, 16 Mar 2004 21:34:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43901-07 for ; Tue, 16 Mar 2004 17:34:29 -0400 (AST) Received: from runa.sytes.net (unknown [200.63.156.127]) by svr1.postgresql.org (Postfix) with ESMTP id 5E34ED1D2F7 for ; Tue, 16 Mar 2004 17:34:26 -0400 (AST) Received: from runa by runa.sytes.net with local (Exim 3.36 #1 (Debian)) id 1B3MGQ-0006Vl-00; Tue, 16 Mar 2004 18:38:18 -0300 Date: Tue, 16 Mar 2004 18:38:18 -0300 From: Martin Sarsale To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: nodeRead: did not find '}' at end of plan node Message-Id: <20040316183818.15cbac00.lists@runa.sytes.net> In-Reply-To: <8062.1079388429@sss.pgh.pa.us> References: <20040315180703.5e27de95.lists@runa.sytes.net> <8062.1079388429@sss.pgh.pa.us> X-Mailer: Sylpheed version 0.9.7 (GTK+ 1.2.10; i386-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/232 X-Sequence-Number: 12801 > Can you do "select * from pg_user" in any of your databases, or does it > fail the same way in all? If it fails in each database then I'd suspect > some kind of version mismatch; if not then it's just corrupt in that > particular database. I've only 2 databases t(template1 and another one) and it didn't worked in any of them Also, I couldn't create the alternate view, I get the same error: xxx:~# psql -U postgres template1 ERROR: nodeRead: did not find '}' at end of plan node Welcome to psql 7.3.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit template1=> template1=> CREATE VIEW my_pg_user AS template1-> SELECT template1-> usename, template1-> usesysid, template1-> usecreatedb, template1-> usesuper, template1-> usecatupd, template1-> '********'::text as passwd, template1-> valuntil, template1-> useconfig template1-> FROM pg_shadow; ERROR: current transaction is aborted, queries ignored until end of transaction block Im running debian stable/testing, postgresql 7.3.2 with a "connect by prior" patch. Thanks in advance On Mon, 15 Mar 2004 17:07:09 -0500 Tom Lane wrote: > Martin Sarsale writes: > > Im running psql (PostgreSQL) 7.3.2 here and since some weeks Im getting this error when trying to dump all databases (to upgrade to pg 7.4.1) > > > \connect XXX > > pg_dump: SQL command failed > > pg_dump: Error message from server: ERROR: nodeRead: did not find '}' at end of plan node > > pg_dump: The command was: select (select usename from pg_user where usesysid = datdba) as dba, encoding, datpath from pg_database where datname = 'emepe3' > > pg_dumpall: pg_dump failed on emepe3, exiting > > It would appear that the view rule for the pg_user view is corrupt, or > at least not quite the same format that the backend code is expecting. > > Can you do "select * from pg_user" in any of your databases, or does it > fail the same way in all? If it fails in each database then I'd suspect > some kind of version mismatch; if not then it's just corrupt in that > particular database. > > We had a similar report last November which seemed to be related to a > glibc update --- see the thread starting here: > http://archives.postgresql.org/pgsql-general/2003-11/msg01102.php > The complainant lost interest after finding a workaround, so we > never did get a complete explanation of what happened, but I'm > suspicious there was some software incompatibility involved, not > data corruption per se. I would like to find out the truth of the > matter. If you are interested you could try manually creating an > equivalent of pg_user, viz > > CREATE VIEW my_pg_user AS > SELECT > usename, > usesysid, > usecreatedb, > usesuper, > usecatupd, > '********'::text as passwd, > valuntil, > useconfig > FROM pg_shadow; > > and then see if you can do "select * from my_pg_user", and if so, > what is the difference between the pg_rewrite entries for the two > views. (See the above-referenced thread for more info.) > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- you can find my public PGP/GPG key at http://www.n3rds.com.ar/files/martin_sarsale.key