[postgis-devel] postgis_proc_upgrade.pl dropping aggregates

[Michael Fuhr]

On Wed, Aug 22, 2007 at 08:55:33AM -0400, Obe, Regina wrote:
> Commented out section on aggregate functions.  I see we are doing a 
> 
> DROP AGGREGATE $aggname($basetype);\n
> 
> I was going to change to do
> 
> DROP AGGREGATE IF EXISTS $aggname($basetype);\n
> 
> But I'm not quite sure when IF EXISTS was introduced into Postgresql.
> Does anyone have an idea when that was introduced and if we did change
> the above to something like that if it would pose problems elsewhere.

IF EXISTS was introduced in PostgreSQL 8.2.

http://www.postgresql.org/docs/8.2/interactive/release-8-2.html

-- 
Michael Fuhr