[postgis-devel] probe_geometry_columns

[Kevin Neufeld]

Markus Schaber wrote:
> Hi, Strk,
>
> strk at refractions.net wrote:
>   
>> The fix_geometry_columns was a quick hack.
>> I'm sure this is better.
>> My only concern is compatibility back to PostgreSQL 7.2.
>> Is there any volunteer for back-porting ?
>>     
>
> I think there won't be an easy way of back porting, as AFAIK the
> exception mechanism does not exist back then (as it internally uses
> savepoints / nested transactions which were introduced in 8.0, I think.)
>   
Correct. The EXCEPTION clause was introduced in 8.0.
> My suggestion is to keep the existing geometry_column functions, and add
> this method under a different name for PostgreSQL 8.X only.
>
> Thanks,
> Markus
>   
I could simply remove all the error catch clauses and just terminate the 
function if an ADD CONSTRAINT query fails .... if that's desirable (as 
well as adding code to support 7.2).


--Kevin

-- 
Kevin Neufeld,
Refractions Research Inc.,
kneufeld at refractions.net
Phone: (250) 383-3022 
Fax:   (250) 383-2140