[postgis] postgis_undef.sql incomplete ??

[Manuel Weindorf]

Hi,

Am I doing something wrong when I try

to remove postgis:

psql -d a_database -f postgis.sql
psql -d a_database -f postgis_undef.sql

to reinstall it:
psql -d a_database -f postgis.sql

While reinstalling I the transaction is always aborted because of already 
defined functions.
So I recognized, that not all the functions/tables were removed by the 
postgis_undef.sql script.

I guess there should be the following commands added to postgis_undef.sql 
somewhere:

---
drop table spatial_ref_sys;
drop table geometry_columns;

drop function find_srid(varchar,varchar,varchar);
drop function geometry(text);
drop function postgis_gist_sel(oid, oid, int2, opaque, int4);

drop function wkb_in(opaque);
drop function wkb_out(opaque); 
---

Best regards 
Manuel

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Pinpoint the right security solution for your company- Learn how to add 128- bit encryption and to authenticate your web site with VeriSign's FREE guide!
http://us.click.yahoo.com/yQix2C/33_CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/