This is fixed in PostGIS 1.4.1 I believe -- due out shortly.
-----Original Message-----
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@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
b...@remoteinformation.com.au
Out here, it pays to
know...
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
