[postgis-devel] probe_geometry_columns

[Kevin Neufeld]

Hi Sandro,

I cut and pasted the code from that I sent on April 12 into a 8.1 
instance and didn't have any problems. Unfortunately, I don't have a 8.0 
instance at my ready to test against that.

The only thing I can think of is that your email client is adding funny 
characters at line breaks or something.

Other ideas?
Cheers,
Kevin


strk at refractions.net wrote:
> Kevin, I was giving your function a try, but it wasn't accepted
> by postgresql 8.0.1:
>
> ERROR:  syntax error at or near "quote_ident" at character 3040
> psql:populate_geometry_columns.sql:184: ERROR:  syntax error at or near "quote_ident" at character 3040
> psql:populate_geometry_columns.sql:184: LINE 81: ... could not apply constraint CHECK (srid(%) = %)', quote_iden...
> psql:populate_geometry_columns.sql:184:
>
> Any idea ?
>
> --strk;
>
> On Wed, Apr 12, 2006 at 12:13:44PM -0700, Kevin Neufeld wrote:
>   
>> Done.
>>
>> Kevin Neufeld wrote:
>>     
>>> Markus Schaber wrote:
>>>       
>>>> >From looking at the code, it seems that this will not work fine for
>>>> "mixed" geometry columns, which can be declared with 'GEOMETRY' as
>>>> geometry type.
>>>>  
>>>>         
>>> Right... forgot about that case. Will make the appropriate change.
>>> Thx
>>>
>>>       
>> -- Kevin
>>     

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