Re: pgsql: Fix calculation of which GENERATED columns need to be updated.

2023-01-07 Thread Tom Lane
David Rowley writes: > On Fri, 6 Jan 2023 at 08:12, Tom Lane wrote: >> Fix calculation of which GENERATED columns need to be updated. >> src/backend/nodes/outfuncs.c | 1 - >> src/backend/nodes/readfuncs.c| 1 - > Is this missing a cat version bump? ... Ugh, you're

pgsql: Check relkind before using TABLESAMPLE in postgres_fdw

2023-01-07 Thread Tomas Vondra
Check relkind before using TABLESAMPLE in postgres_fdw Check the remote relkind before trying to use TABLESAMPLE to acquire sample from the remote relation. Even if the remote server version has TABLESAMPLE support, the foreign table may point to incompatible relkind (e.g. a view or a sequence).

pgsql: psql: Add support for \dpS and \zS.

2023-01-07 Thread Dean Rasheed
psql: Add support for \dpS and \zS. This allows an optional "S" modifier to be added to \dp and \z, to have them include system objects in the list. Note that this also changes the behaviour of a bare \dp or \z without the "S" modifier to include temp objects in the list, and exclude

Re: pgsql: Fix calculation of which GENERATED columns need to be updated.

2023-01-07 Thread David Rowley
On Fri, 6 Jan 2023 at 08:12, Tom Lane wrote: > > Fix calculation of which GENERATED columns need to be updated. > Branch > -- > master > src/backend/nodes/outfuncs.c | 1 - > src/backend/nodes/readfuncs.c| 1 - Is this missing a cat version bump? David