Thread: ERROR: scanNameSpaceForRefname: unexpected node type 0

ERROR: scanNameSpaceForRefname: unexpected node type 0

From
"Gibellini Paolo"
Date:
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.gibellini@teinos.com

Re: ERROR: scanNameSpaceForRefname: unexpected node type 0

From
Tom Lane
Date:
"Gibellini Paolo" <p.gibellini@teinos.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