| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martin Goodson <kaemaril(at)googlemail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' |
| Date: | 2026-03-13 02:22:49 |
| Message-ID: | 4799.1773368569@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martin Goodson <kaemaril(at)googlemail(dot)com> writes:
> I've exported some views from a PG14 database and loaded them into a
> brand new PG17 database via a plain text format pg_dump.
> No errors were reported during the dump, so no problems creating the
> views reported.
> However, attempting to query the views - which are pretty complex, to be
> fair - result in the query erroring immediately with 'ERROR:
> unrecognized node type: 2'
That is certainly a bug, but there's zero hope of anyone fixing it
without a reproducible test case to poke at.
Looking at our commit log, there was a fix in 17.3 for a problem that
resulted in "unrecognized node type" errors [1], so it'd behoove you to
make sure you are running 17.recent before spending any more effort.
regards, tom lane
[1] https://www.postgresql.org/message-id/flat/18778-24cd399df6c806af%40postgresql.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ishan joshi | 2026-03-13 09:33:26 | correct formula for calculating distance t transaction and distance to snapshot |
| Previous Message | Michael Paquier | 2026-03-13 02:00:32 | Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' |