Re: alter check constraint enforceability

2025-08-11 Thread Kirill Reshke
On Mon, 11 Aug 2025 at 14:53, jian he wrote: > > On Thu, Aug 7, 2025 at 7:35 AM Robert Treat wrote: > > > > + if (rel->rd_rel->relkind == RELKIND_RELATION && > > + cmdcon->is_enforced && > > + !currcon->conenforced) > > > > i think I have convinced myself that this is correct, but maybe I

Re: alter check constraint enforceability

2025-08-11 Thread jian he
so here you don't need to consider RELKIND_PARTITIONED_TABLE. From a54609c8aa66174e171fdfd7c08519e587561d85 Mon Sep 17 00:00:00 2001 From: jian he Date: Mon, 11 Aug 2025 17:51:56 +0800 Subject: [PATCH v3 1/1] alter check constraint enforceability syntax: ALTER TABLE ALTER CONSTRAINT [NOT] ENFOR

Re: alter check constraint enforceability

2025-08-06 Thread Robert Treat
On Fri, Jul 4, 2025 at 8:00 AM jian he wrote: > > On Mon, Jun 2, 2025 at 9:57 PM jian he wrote: > > > > Currently in pg18, we can add not enforced check constraints. > > but we can not do ALTER TABLE ALTER CONSTRAINT [NOT] ENFORCED > > for check constraint. > > > > The attached patch is implemen

Re: alter check constraint enforceability

2025-07-04 Thread jian he
check constraint. hi. rebase and minor refactoring. From ba604766c43e474aa6b08ba613dfb04854ec7f40 Mon Sep 17 00:00:00 2001 From: jian he Date: Fri, 4 Jul 2025 19:51:43 +0800 Subject: [PATCH v2 1/1] alter check constraint enforceability syntax: ALTER TABLE ALTER CONSTRAINT [NOT] ENF

alter check constraint enforceability

2025-06-02 Thread jian he
:00:00 2001 From: jian he Date: Mon, 2 Jun 2025 21:54:53 +0800 Subject: [PATCH v1 1/1] alter check constraint enforceability context: https://git.postgresql.org/cgit/postgresql.git/commit/?id=ca87c415e2fccf81cec6fd45698dde9fae0ab570 discussion: https://postgr.es/m/ --- doc/src/sgml/ref