| From: | Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Johann 'Myrkraverk' Oskarsson <johann(at)myrkraverk(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Retroactively adding send and recv functions to a type? |
| Date: | 2019-08-20 02:27:42 |
| Message-ID: | 64b6e379-a234-e515-59f9-db025a848831@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 19/08/2019 19:32, Tom Lane 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.
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.
--
Vik Fearing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2019-08-20 03:40:29 | Re: SELECT all the rows where id is children of other node. |
| Previous Message | pabloa98 | 2019-08-20 01:42:53 | SELECT all the rows where id is children of other node. |