From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Manuel Kniep <manuel(at)adjust(dot)com> |
Cc: | Manuel Kniep <m(dot)kniep(at)web(dot)de>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ALTER TYPE ADD SEND AND RECEIVE |
Date: | 2014-12-12 02:07:15 |
Message-ID: | 22688.1418350035@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Manuel Kniep <manuel(at)adjust(dot)com> writes:
> On 11. Dezember 2014 at 00:08:52, Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
>> 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.
> I also thought about this but I guess I have to INSERT the dependency in pg_depend too.
Personally, I wouldn't bother with that. Good practice would be to have
any such type packaged as an extension; so if you add the new functions
to the extension (which is supported) there's no need to be terribly
tense about the intra-extension dependencies. But even if you didn't
do that, the worst consequence of dropping the functions would be
"cache lookup failed" errors.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-12-12 03:58:40 | Re: Documentation missing bigint? |
Previous Message | David G Johnston | 2014-12-11 22:55:37 | Re: Help Optimizing a Summary Query |