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

udgment. > > I liked the idea. So, follows the patches: - 0001-btree_gin-uuid--base.v2.patch - all types but anyrange, and with the adjustments on comments you proposed - 0002-btree_gin-uuid--anyrange.v2.patch - adding the anyrange type (must be applied after 0001) Anything else missing? Be

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

tree_gin.so" > > Ouch... My fault, filterdiff is acting weird for some reason... Here is the corrected versions... I tested here applying on a clean master just to be sure, all looks good. Very sorry about that mess. I hope it can get in v11, it is a patch so simple, but so useful fo

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

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] 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

as ended, > 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 clea

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

[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

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

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

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

Em 2 de mar de 2018 08:15, "Andres Freund" 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. This patch has been submi

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] 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 we already have gist/spgist opc

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

27;m OK with changing 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_tabl

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: found xmin from before relfrozenxid on pg_catalog.pg_authid

.init` 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: 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

et you know. 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: [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"