On Tue, 17 Sep 2002, Tom Lane wrote:
> > I am waiting the result of the pg_dump from 7.2.x to 7.3 restore discussion.
>
> Right. We clearly have to support loading of 7.2 dumps; the only issue
> in my mind is exactly how we kluge that up ;-). I just talked to Bruce
> about this a little bit, and we came to the conclusion that there are
> two plausible-looking paths:
>
> 1. Relax CREATE LANGUAGE to accept either LANGUAGE_HANDLER or OPAQUE as
> the datatype of the function (ie, make it work more like CREATE TRIGGER
> does).
>
> 2. Hack CREATE LANGUAGE so that if it's pointed at an OPAQUE-returning
> function, it actually updates the recorded return type of the function
> in pg_proc to say LANGUAGE_HANDLER.
Stupid question, but why not just create an upgrade script that does any
required translations external to the database?