Restore from pre-v7.3 -> v7.3 (Was: Re: RPMS for 7.3 beta.) - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Restore from pre-v7.3 -> v7.3 (Was: Re: RPMS for 7.3 beta.)
Date
Msg-id 20020918221854.H53125-100000@hub.org
Whole thread Raw
In response to Re: RPMS for 7.3 beta.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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?




pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: BLOB
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [GENERAL] PGXLOG variable worthwhile?