| 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 |