Re: Retroactively adding send and recv functions to a type? - Mailing list pgsql-general

From Stephen Frost
Subject Re: Retroactively adding send and recv functions to a type?
Date
Msg-id 20190820143614.GP16436@tamriel.snowman.net
Whole thread Raw
In response to Re: Retroactively adding send and recv functions to a type?  (Vik Fearing <vik.fearing@2ndquadrant.com>)
Responses Re: Retroactively adding send and recv functions to a type?
List pgsql-general
Greetings,

* Vik Fearing (vik.fearing@2ndquadrant.com) wrote:
> On 19/08/2019 19:32, Tom Lane wrote:
> > "Johann 'Myrkraverk' Oskarsson" <johann@myrkraverk.com> writes:
> >> I meant ALTER TYPE.  Adding the send and recv functions doesn't seem
> >> to supported by ALTER TYPE.
> >> Is there a workaround for this?
> > You could manually update the pg_type row, and then if you were
> > being fussy, add pg_depend entries showing the type depends on
> > the functions.
>
> We generally discourage updating the catalogs directly.  This was why I
> wrote the CREATE/ALTER DATABASE patch in 2014 that you helped me with
> (fbb1d7d73f8).
>
> I'm willing to work on a patch for ALTER TYPE if it has a chance of
> being accepted.

Seems pretty clear that it'd be a useful thing to have, so +1 from me,
at least.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: postmaster utilization
Next
From: Ubence Quevedo
Date:
Subject: RE: Can't install postgresql from official postgresql repo on RedHat8?