| From: | shveta malik <shveta(dot)malik(at)gmail(dot)com> |
|---|---|
| To: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
| Cc: | vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Smith <smithpb2250(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com> |
| Subject: | Re: Support EXCEPT for ALL SEQUENCES publications |
| Date: | 2026-06-26 08:53:04 |
| Message-ID: | CAJpy0uCV-L8DP+AfZq2Rj1xEjyzwZW-ugfmmXMPpotiyNTHG_A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Please find a few trivial comments on v13-001:
1)
check_publication_add_relation:
+ * 'pubrelkind' is the relkind accepted by the publication clause,
+ * while 'targetrelkind' is the relkind of the relation being added.
pubrelkind is the argument while targetrelkind is not. We generally
explain arguements here.
Can we rephrase to:
* 'pubrelkind' is the relkind accepted by the publication clause.
* The relkind of relation in given 'pri' is checked for compatibility
* against it. Error is emitted if they are not compatible.
2)
describePublications:
}
- else
+ if (puballtables)
{
Now since else is converted to independent 'if' block we can add a
blank line before it for better readability.
Same for this:
}
+ if (puballsequences)
+ {
3)
We have each test header like below starting from begining of file:
---------------------------------------------
-- Tests for inherited tables, and
-- EXCEPT clause tests for inherited tables
---------------------------------------------
---------------------------------------------
-- EXCEPT clause tests for partitioned tables
---------------------------------------------
So we can convert ours too in above format so that it is more visible:
+-- Test ALL SEQUENCES with EXCEPT clause
4)
We can add these tests to sql file:
a) SEQ keyword equivalent test to below table one:
-- fail - first table in the EXCEPT list should use TABLE keyword
CREATE PUBLICATION testpub_foralltables_excepttable2 FOR ALL TABLES
EXCEPT (testpub_tbl1, testpub_tbl2);
b) Try to add either of temporay or unlogged seq to except list.
thanks
Shveta
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chao Li | 2026-06-26 08:58:50 | Clear base backup progress reporting on error |
| Previous Message | Michael Paquier | 2026-06-26 08:12:15 | Re: [PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks |