Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

the approach, we just need to chose the color :D I believe this is a small change in source code, but with huge impact for users with big tables. Would be great if it could go in PG 13. Best regards, -- Matheus de Oliveira diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

Sorry about the long delay in answering that, I hope to get to a consensus on how to do that feature, which I think it is really valuable. Sending few options and observations bellow... On Sun, Jul 28, 2019 at 2:37 PM Tom Lane wrote: > Matheus de Oliveira writes: > > [ postgre

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

On Mon, Jul 1, 2019 at 6:21 AM Thomas Munro wrote: > > Hi Matheus, > > As the commitfest is starting, could you please send a rebased patch? > > Hi all, Glad to start working on that again... Follows the rebased version (at 5925e55498). Thank you all. Best regards, -- M

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

> I'm marking this patch as returned with feedback. Please resubmit once > that's fixed. > > Hi all. Sorry for the long delay. I've rebased the patch to current master (at f2004f19ed now), attached as postgresql-alter-constraint.v4.patch. All tests passed cleanly. Best regards, -- M

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

hread? Best regards, -- Matheus de Oliveira diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index f13a6cd944..5910680cf3 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -55,7 +55,9 @@ ALTER TABLE [ IF EXISTS ] name AL

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

Hi all. Sorry about the long delay. On Tue, Jul 10, 2018 at 10:17 AM Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > On Wed, Mar 7, 2018 at 11:49 PM, Matheus de Oliveira > wrote: > > > > > > Em 3 de mar de 2018 19:32, "Peter Eisentraut"

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

w. I applied the work around in the affected server and seemed to work way, so far no error. Thank you a lot for all the information and help. Best regards, -- Matheus de Oliveira

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

On Tue, Jun 19, 2018 at 12:53 PM, Andres Freund wrote: > Hi, > > On 2018-06-19 10:26:26 -0300, Matheus de Oliveira wrote: > > Hello friends. > > > > On Tue, Jun 12, 2018 at 3:31 PM, Andres Freund > wrote: > > > > > > > > On 2018-06-11 17:

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

` file is really the way to go, and the details, is it safe? Should I stop the server, delete, start?) Best regards, -- Matheus de Oliveira

Re: [PATCH] btree_gin, add support for uuid, bool, name, bpchar and anyrange types

; for range it should different index structure to be useful. > > Makes sense. Better leave it out then ;) Thanks a lot you all for the hard work and patience with me! Best regards, -- Matheus de Oliveira

Re: [PATCH] btree_gin, add support for uuid, bool, name, bpchar and anyrange types

mple, but so useful for many people. Best regards, -- Matheus de Oliveira diff --git a/contrib/btree_gin/Makefile b/contrib/btree_gin/Makefile new file mode 100644 index 690e1d7..a9e9925 *** a/contrib/btree_gin/Makefile --- b/contrib/btree_gin/Makefile *** OBJS = btree_gin.o $(WIN32RE

Re: [PATCH] btree_gin, add support for uuid, bool, name, bpchar and anyrange types

) Anything else missing? Best regards, -- Matheus de Oliveira diff --git a/contrib/btree_gin/Makefile b/contrib/btree_gin/Makefile index 690e1d7..a9e9925 100644 *** a/contrib/btree_gin/Makefile --- b/contrib/btree_gin/Makefile *** *** 5,17 OBJS = btree_gin.o $(WIN32RES) EXTENSION

Re: [PATCH] btree_gin, add support for uuid, bool, name, bpchar and anyrange types

Hi all. Em 4 de mar de 2018 16:00, "Tomas Vondra" escreveu: 1) I personally am not that sure GIN indexes on ranges are very useful, considering those columns are usually queried for containment (i.e. is this value contained in the range) rather than equality. And

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

Em 3 de mar de 2018 19:32, "Peter Eisentraut" < peter.eisentr...@2ndquadrant.com> escreveu: On 2/20/18 10:10, Matheus de Oliveira wrote: > Besides that, there is a another change in this patch on current ALTER > CONSTRAINT about deferrability options. Previously, i

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

Em 2 de mar de 2018 08:15, "Andres Freund" <and...@anarazel.de> escreveu: Hi, On 2018-02-20 12:10:22 -0300, Matheus de Oliveira wrote: > I attached a patch to add support for changing ON UPDATE/DELETE actions of > a constraint using ALTER TABLE ... ALTER CONSTRAINT

Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT

ow if I did something wrong, and if you see improvements on the patch ;) [1] https://commitfest.postgresql.org/17/1533/ Regards, -- Matheus de Oliveira

[PATCH] btree_gin, add support for uuid, bool, name, bpchar and anyrange types

sense to me). So I added support for all of them. If you have any other type I missed and you wish to have support to, please let me know and I can add it. Thanks a lot. Regards, -- Matheus de Oliveira diff --git a/contrib/btree_gin/Makefile b/contrib/btree_gin/Makefile index 690e1d7..d36f5ad