Search Postgresql Archives

Re: ERROR: unrecognized node type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 9/29/21 10:54 AM, Amine Tengilimoglu wrote:
I thought that the server version can be guess from the screenshot . I

Unless folks are using plain text only email readers. That is why screenshots are generally a bad idea for textual information. For the record the Postgres version is 12.8.

already update the latest minor pg version and it didn't work :)

You will need to update with the actual minor version.


When you do the pg_dump, what is the error message?


    Thank you Tom.

Tom Lane <tgl@xxxxxxxxxxxxx>, 29 Eyl 2021 Çar, 20:16 tarihinde şunu yazdı:

Amine Tengilimoglu <aminetengilimoglu@xxxxxxxxx> writes:
   I am getting  the "ERROR:  unrecognized node type: 223" when I execute
\d
combinations in psql and even when getting backup with pg_dump...
probably
the same error will occur with other commands.  What is causing this
issue,
any idea? How to fix it?

You're not going to get any useful responses to that without more
details (at minimum, the server version).  However, a reasonable
bet is that some stored view or expression contains a parse node
that some part of the server code is failing to cope with.  We've
had such bugs in the past, but I don't know of any that are live
right now ... so maybe your answer is just "update to current
minor release".

If that doesn't help, it'd be good to try to isolate which database
object contains the problem, and then reconstruct what its definition
was, so we can try to understand where the oversight is.

                         regards, tom lane




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux