use function which searches through this tables: -pg_constraint -pg_trigger
On Wed, Feb 2, 2011 at 11:21 PM, creationw <mr.creation.regis...@gmail.com>wrote: > > Hello, > > > I found that DROP CONSTRAINT [ IF EXISTS ] is available in Postgres 9.1 > http://developer.postgresql.org/pgdocs/postgres/sql-altertable.html > http://developer.postgresql.org/pgdocs/postgres/sql-altertable.html > > > But it is not avaiable in Postgres 8.1 > http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html > http://www.postgresql.org/docs/8.1/interactive/sql-altertable.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.com/How-to-workaround-DROP-CONSTRAINT-IF-EXISTS-in-Postgres-version-8-1-tp3368570p3368570.html > Sent from the PostgreSQL - sql mailing list archive at Nabble.com. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- --------------------------------------- Viktor Bojović --------------------------------------- Wherever I go, Murphy goes with me
