Re: ERROR: scanNameSpaceForRefname: unexpected node type 0

Lists: pgsql-bugs
From: "Gibellini Paolo" <p(dot)gibellini(at)teinos(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: ERROR: scanNameSpaceForRefname: unexpected node type 0
Date: 2002-07-31 17:20:19
Message-ID: 000501c238b6$8f37fe50$6027000a@gibeteinos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Hello.
I have a 7.2 PostgreSQL Server working on a Debian and this afternoon during
a huge query I receive an unespected error message who terminate query
execution.
After this, every time I search to connect to whatever Database (e.g. with
psql) I receive this error message:

ERROR: scanNameSpaceForRefname: unexpected node type 0

Now, I have a backup of my data, but the problem persists dropping and
re-creating databases.
Can anybody suggest me how to do?
Shall I re-install PostgreSQL?

Thank you,
Paolo Gibellini
p(dot)gibellini(at)teinos(dot)com


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gibellini Paolo" <p(dot)gibellini(at)teinos(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ERROR: scanNameSpaceForRefname: unexpected node type 0
Date: 2002-08-02 19:35:49
Message-ID: 14584.1028316949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"Gibellini Paolo" <p(dot)gibellini(at)teinos(dot)com> writes:
> I have a 7.2 PostgreSQL Server working on a Debian and this afternoon during
> a huge query I receive an unespected error message who terminate query
> execution.

Which was what, exactly?

> After this, every time I search to connect to whatever Database (e.g. with
> psql) I receive this error message:

> ERROR: scanNameSpaceForRefname: unexpected node type 0

I'm guessing you have a broken view somewhere, but there's really not
enough info here to say more. It could also be that the postgres
executable file is corrupted; you might try reinstalling that.

regards, tom lane