Mark Cave-Ayland pisze:
Mateusz Naskręt -GEOPOZ- wrote:
So you think that best way is to make single dump for every
table/sequence ? How to do that if i have lots of tables (about 500),
views and sequences ? And how to dump user functions ?
For such a large number of tables, no. I'd go for option 2.
I am not sure if my description in first email was clear enough. For
every function from list (and only them):
public.asgml(geometry, integer, integer)
public.asukml(geometry, integer, integer)
public.asukml(geometry, integer)
public.asukml(geometry)
public.st_pointn(geometry)
i have same error: missing "$libdir/liblwgeom.so.1.2". So something
like that:
CREATE FUNCTION asgml(geometry, integer, integer) RETURNS text
AS '$libdir/liblwgeom.so.1.2', 'LWGEOM_asGML'
LANGUAGE c IMMUTABLE STRICT;
ERROR: could not access file "$libdir/liblwgeom.so.1.2": No suchfile
or directory
I was looking to file lwpostgis.sql - and there are no such functions !
(asukml at all, asgm and st_pointn exist but with different arguments) .
Hmmm are you sure that you've uninstalled PostGIS 1.2.x? Is there
actually a liblwgeom.so.1.2 in the PostgreSQL lib directory?
Another question. Is there a way to check if my Postgis is ok after
upgrade ?
No official way at the moment, other than running the regression tests.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
.
It is new server with postgis 1.3.5 installed so no possibilty to have
liblwgeom.so.1.2 there.
In general i have allready made an upgrade and in very big log from
upgrade exept this 6 functions everything looks fine.
About 10 persons is using this new DB now and till now no informatio
about problems/errors.
So i am asking just to be sure if there may be problems in future.
I have created new empty DB and loaded there lwpostgis.sql. I have
checked there and i haven't found there any of function mentioned above
(this 6 with errors). So maybe these are some old functions used in
previous postgis version and are deprecated in current version ? What do
you think ?
Mateusz Naskręt
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
