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

From Johann 'Myrkraverk' Oskarsson
Subject Re: Retroactively adding send and recv functions to a type?
Date
Msg-id CAA_SOw8R8Gnx-7cOAum4TC5wkUjEo725k4JevjjnUcM8ghLgug@mail.gmail.com
Whole thread Raw
In response to Re: Retroactively adding send and recv functions to a type?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Retroactively adding send and recv functions to a type?
List pgsql-general
On Tue, Aug 20, 2019 at 1:32 AM Tom Lane <tgl@sss.pgh.pa.us> 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.

Can I do this in a future proof way?  That is, is there a way to make
that into an upgrade script, or will I make the extension
un-upgradable doing that?


-- 
Johann

 I'm not from the internet, I just work there.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Retroactively adding send and recv functions to a type?
Next
From: Tom Lane
Date:
Subject: Re: Retroactively adding send and recv functions to a type?