Horton
Menu

Re: Pgoutput not capturing the generated columns

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda@hpe.com>, vignesh C <vignesh21@gmail.com>, Peter Smith <smithpb2250@gmail.com>, Shubham Khanna <khannashubham1197@gmail.com>, Masahiko Sawada <sawada.mshk@gmail.com>, Rajendra Kumar Dangwal <dangwalrajendra888@gmail.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>, "euler@eulerto.com" <euler@eulerto.com>
Date: 2024-12-10T06:50:43Z
Lists: pgsql-hackers 
On Thu, Nov 07, 2024 at 03:46:54PM +0530, Amit Kapila wrote:
> Can we slightly modify it as: "If true, this publication replicates
> the generated columns in the tables associated with the publication."?
> BTW, we might want to say: "If true, this publication replicates the
> stored generated columns in the tables associated with the
> publication." depending on the point Peter E. has raised, so, let's
> wait for the conclusion.

Yeah, the state of things is unclear to me..  As of now this thread is
just waiting on author and idle in the CF app for no real purpose.  I
have marked it as returned with feedback, and I'd suggest to come back
to it and resubmit once the horizon is clear (one item being related
to virtual generated columns).
--
Michael

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Doc: Generated column replication.

  2. Rename pubgencols_type to pubgencols in pg_publication.

  3. Doc: Fix column name in pg_publication catalog.

  4. Fix buildfarm failure introduced by commit e65dbc9927.

  5. Change publication's publish_generated_columns option type to enum.

  6. Fix \dRp+ output when describing publications with a lower server version.

  7. Replicate generated columns when 'publish_generated_columns' is set.

  8. Doc: Update the behavior of generated columns in Logical Replication.

  9. Replicate generated columns when specified in the column list.

  10. Doc: Generated columns are skipped for logical replication.