Обсуждение: ERROR: scanNameSpaceForRefname: unexpected node type 0
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
"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