Re: Support EXCEPT for ALL SEQUENCES publications

Peter Smith <smithpb2250@gmail.com>

From: Peter Smith <smithpb2250@gmail.com>
To: Shlok Kyal <shlok.kyal.oss@gmail.com>
Cc: Ashutosh Sharma <ashu.coek88@gmail.com>, shveta malik <shveta.malik@gmail.com>, vignesh C <vignesh21@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-07-01T23:22:32Z
Lists: pgsql-hackers
Only trivial comments for v16*

//////
v16-0001
//////

======
src/bin/pg_dump/pg_dump.c

getPublictions:

1.
  /*
- * Get the list of tables for publications specified in the EXCEPT
- * TABLE clause.
+ * Get the list of tables and sequences for publications specified in
+ * the EXCEPT clause.
  *

Perhaps this comment should say that EXCEPT (TABLE ...) is introduced
in PG19, and EXCEPT (SEQUENCE ...) is introduced in PG20. That way
there are no surprises about the different version checks that follow.

======
src/test/subscription/t/037_except.pl

2.
+# Check the initial data on subscriber
+$result = $node_subscriber->safe_psql('postgres',
+ "SELECT last_value, is_called FROM seq_excluded_in_pub1");
+is($result, '1|f', 'sequences in EXCEPT list is excluded');

typo: plural. Should be "sequences in the EXCEPT list are excluded"

//////
v16-0002
//////

======
src/test/subscription/t/037_except.pl

1.
+is($result, '1|f', 'sequences in EXCEPT list is excluded');

typo: plural. Should be "sequences in the EXCEPT list are excluded"

======
Kind Regards,
Peter Smith.
Fujitsu Australia



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: Clarify that publication exclusions track table identity.

  2. Use schema-qualified names in EXCEPT clause error messages.

  3. psql: Improve describe footer titles for publications.

  4. Improve various new-to-v19 appendStringInfo calls