pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1?
2+ messages / 2 participants
[nested] [flat]
* How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1?
@ 2011-02-02 22:21 creationw <mr.creation.register@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: creationw @ 2011-02-02 22:21 UTC (permalink / raw)
To: pgsql-sql
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-vers...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1?
@ 2011-02-04 08:33 Viktor Bojović <viktor.bojovic@gmail.com>
parent: creationw <mr.creation.register@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Viktor Bojović @ 2011-02-04 08:33 UTC (permalink / raw)
To: creationw <mr.creation.register@gmail.com>; +Cc: pgsql-sql
use function which searches through this tables:
-pg_constraint
-pg_trigger
On Wed, Feb 2, 2011 at 11:21 PM, creationw
<mr.creation.register@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-vers...
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-02-04 08:33 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-02 22:21 How to workaround DROP CONSTRAINT [ IF EXISTS ] in Postgres version 8.1? creationw <mr.creation.register@gmail.com>
2011-02-04 08:33 ` Viktor Bojović <viktor.bojovic@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox