Re: Retroactively adding send and recv functions to a type?

From: "Johann 'Myrkraverk' Oskarsson" <johann(at)myrkraverk(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Retroactively adding send and recv functions to a type?
Date: 2019-08-19 17:46:14
Message-ID: CAA_SOw8R8Gnx-7cOAum4TC5wkUjEo725k4JevjjnUcM8ghLgug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 20, 2019 at 1:32 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Johann 'Myrkraverk' Oskarsson" <johann(at)myrkraverk(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shital A 2019-08-19 18:06:56 Re: Pgsql resource agent of pacemaker
Previous Message Tom Lane 2019-08-19 17:32:19 Re: Retroactively adding send and recv functions to a type?