Re: pg_get_sequence_data Shows Non-NULL last_value for Freshly Created Sequence - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_get_sequence_data Shows Non-NULL last_value for Freshly Created Sequence
Date
Msg-id 1181763.1755709312@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_get_sequence_data Shows Non-NULL last_value for Freshly Created Sequence  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: pg_get_sequence_data Shows Non-NULL last_value for Freshly Created Sequence
List pgsql-hackers
Nathan Bossart <nathandbossart@gmail.com> writes:
> This function returns the values in the sequence tuple, primarily for
> pg_dump (see commit bd15b7d).  IIUC your patch would break pg_dump on v18
> and newer versions.

The proposed patch includes a change to pg_dump that I suppose is
meant to compensate.  But I'm not 100% sure that it does so correctly.
Anyway, given that it's supposed to provide low-level inspection of
the sequence tuple, I think that it's best not to be too cute.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Organize working memory under per-PlanState context
Next
From: Tomas Vondra
Date:
Subject: Re: Changing the state of data checksums in a running cluster