Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER EXTENSION ... UPGRADE; - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: ALTER EXTENSION ... UPGRADE;
Date
Msg-id 87sjy1646i.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: ALTER EXTENSION ... UPGRADE;  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Tom Lane <tgl@sss.pgh.pa.us> writes:
> I see no advantage of this over a script per version combination, so
> long as you allow scripts to \include each other.

I guess the following should do:
 SELECT pg_execute_sql_file('upgrade-1.sql');

But I rather prefer the 2-liner control file, myself:
 upgrade-1.* = 'upgrade-1.sql' upgrade-2.* = 'upgrade-2.sql'

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL/MED - file_fdw
Next
From: Florian Pflug
Date:
Subject: Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE