On Thu, Sep 20, 2012 at 06:51:02PM -0700, Phil Hurvitz wrote: > So what I think I want to do is install the updated types from the > postgis extension to the public schema, and then drop those types > from the gis schema. Looks like a real mess since I can't seem to > cast geometries in one schema to geometries in another schema.
Have you tried something like this ? ALTER TABLE tab ALTER COLUMN col TYPE public::geometry USING public::geometry(col::text); --strk; http://www.cartodb.com - Map, analyze and build applications with your data ~~ http://strk.keybit.net _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
