Re: [Gnumed-bugs] Problem CONSTANTCONTEXT trying to update db 15 --> 16 from git source

[Karsten Hilbert]

On Sat, Aug 20, 2011 at 12:50:46AM -0700, Jim Busser wrote:

> > the version of PostgreSQL you are on does not yet
> > support this plpgsql construct:
> > 
> >     DECLARE
> >             _tmp alias for $1;
> >     BEGIN
> >             _tmp := 1;
> >     END;
> 
> Is this construct something you
> 
> (a) prefer to require (so that you are not limited by an overly low community 
> level of Postgres) or

In which case the fix would've been to require PG v9.0 in
the bootstrapper script which is a bit premature.

> (b) wish to postpone using, so that GNUmed can continue to be able to 
> bootstrapped with the older construct?

B), which is the fix I (now) checked in.

> If (a) then I can soon upgrade to 9.0.

For a production database we would strongly recommend 9.0.latest.

> If (b) then I can keep using PostgreSQL 8.4 and in that way be able to test 
> backwards compatibility :-)

That's good to have (as in the example on hand).

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346