dbTalk Databases Forums  

[SQL] How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version8.1?

mailing.database.pgsql-sql mailing.database.pgsql-sql


Discuss [SQL] How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version8.1? in the mailing.database.pgsql-sql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
creationw
 
Posts: n/a

Default [SQL] How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version8.1? - 02-02-2011 , 04:21 PM






Hello,


I found that DROP CONSTRAINT [ IF EXISTS ] is available in Postgres 9.1
http://developer.postgresql.org/pgdo...ltertable.html
http://developer.postgresql.org/pgdo...ltertable.html


But it is not avaiable in Postgres 8.1
http://www.postgresql.org/docs/8.1/i...ltertable.html
http://www.postgresql.org/docs/8.1/i...ltertable.html


Is there a way to achieve this on Postgres 8.1?

Thanks a lot
--
View this message in context: http://postgresql.1045698.n5.nabble....0p3368570.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.