[postgis-users] PostgreSQL 7.3 Support

carl anderson candrsn at mindspring.com
Thu Dec 5 17:58:04 PST 2002


under PostgreSQL 7.3

createdb -T template0 test;
psql test < postgis.sql
psql < spatial_ref_sys.sql

succeeds

after that

psql test < postgis_undef.sql fails

first I edited postgis_undef.sql to have
drop AGGREGATE extent (geometry);
drop AGGREGATE collect (geometry);

but then
   DROP AGGREGATE
   DROP AGGREGATE
   ERROR:  cache lookup of opclass 34433 failed

of course the oid of the opclass is specific to my installation.


It appears that PostgreSQL 7.3 uses stronger operator/function/operator 
class
type checking;

I have previously had success with an undef using
    drop type geometry cascade;
which won't work with older PostgreSQL versions



I checked the Mapserver CVS and did not find any change to mappostgis.c 
there.
Will anyone there submit a patch so that testing with mapserver can be 
made?




On 2002.12.05 16:56 Paul Ramsey wrote:
> PostGIS'ers.
> 
> The CVS version now contains beta quality support for PgSQL 7.3. This 
> has not been particularly tested at all (loaded one Shape file, 
> checked indexes, added some typecasting support) so your milage may 
> vary. Any bugs report back to the list please.
> 
> Paul
> 
>-- 
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey at refractions.net
>      | Phone: (250) 885-0632
>      \_
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list