| From: | Peter Smith <smithpb2250(at)gmail(dot)com> |
|---|---|
| To: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
| Cc: | Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Support EXCEPT for ALL SEQUENCES publications |
| Date: | 2026-07-01 23:22:32 |
| Message-ID: | CAHut+PuC7qCdBUcCL1DeQEuRJsp-PU-n7_Jd4Hs-REn9M5ZO4g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chao Li | 2026-07-01 23:45:34 | Re: Clear base backup progress reporting on error |
| Previous Message | Nico Williams | 2026-07-01 23:20:23 | Re: Global temporary tables |