[postgis-users] Or don't install postgis on a different schema!!

[Paragon Corporation]

This is fixed in PostGIS 1.4.1 I believe -- due out shortly. 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ben
Madin
Sent: Thursday, November 26, 2009 5:08 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Or don't install postgis on a different
schema!!

Arrgh! it was so likely to happen that Murphy would be proud,


On 26/11/2009, at 12:14 , Ben Madin wrote:

> create schema postgis;
> 
> set search_path postgis, other schemas;
> 
> \i postgis.sql -- or you could set the search_path in the postgis_sql file
- there used to be some problems here with schema qualified table /
functions names in the postgis.sql, but I think they are mainly gone now.


So I come back from lunch, and realise that tables I have dumped and
imported across databases (so -Ox no owner, no priviliges) neither seem to
dump with any constraints,

no worries I think, use populate_geometry_columns();

prices=# select populate_geometry_columns('gms.road'::regclass);
ERROR:  function public.srid(geometry) does not exist LINE 1: SELECT
public.srid(the_geom) 
              ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
QUERY:  SELECT public.srid(the_geom) 
	             FROM ONLY gms.road 
	             WHERE the_geom IS NOT NULL LIMIT 1
CONTEXT:  PL/pgSQL function "populate_geometry_columns" line 54 at EXECUTE
statement

Whoops!

Is this required to be in the public schema? I have gone around it by
unqualifying the functions, is there any reason to have them qualified?

cheers

Ben




-- 

Ben Madin
REMOTE INFORMATION

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben at remoteinformation.com.au



							Out here, it pays to
know...


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users