[postgis] Unable to drop contraint

[Paul Ramsey]

Create new table with same data def, but not constraint. 
Select data from old into new.
Delete old.
Rename new to old.

John Reid wrote:
> 
> *@#%$!  Postgresql doesn't allow the dropping of a contraint using ALTER
> TABLE.  Anyone have an alternative idea?
> 
> --
> ----------------------------------------------------------------------
> john reid                                     e-mail jgreid at uow.edu.au
> 
> uproot your questions from their ground and the dangling roots will be
> seen.  more questions!
>                                                        -mentat zensufi
> 
> apply standard disclaimers as desired...
> ----------------------------------------------------------------------
> 
> 
> 
> 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/

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_

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/