Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TYPE ADD SEND AND RECEIVE - Mailing list pgsql-general

From Tom Lane
Subject Re: ALTER TYPE ADD SEND AND RECEIVE
Date
Msg-id 31302.1418252788@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TYPE ADD SEND AND RECEIVE  (Manuel Kniep <m.kniep@web.de>)
Responses Re: ALTER TYPE ADD SEND AND RECEIVE  (Manuel Kniep <manuel@adjust.com>)
List pgsql-general
Tree view 
Manuel Kniep <m.kniep@web.de> writes:
> I have a custom type and want to add the yet missing  SEND and RECEIVE functions
> is there anyway to alter the type definition without dropping and recreating it?

There's no supported way to do that.  As an unsupported way, you could
consider a manual UPDATE on the type's pg_type row.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: new index type with clustering in mind.
Next
From: vicky
Date:
Subject: Re: Integrating C++ singletons into postgresql extensions???