DROP CONSTRAINT IF EXISTS - simulating in 7 and 8?

From: Lyle <webmaster(at)cosmicperl(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DROP CONSTRAINT IF EXISTS - simulating in 7 and 8?
Date: 2010-07-25 03:03:48
Message-ID: 4C4BA994.4090400@cosmicperl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I really like the new:-
ALTER TABLE *table* DROP CONSTRAINT IF EXISTS *contraint*
But I need to achieve the same thing on earlier versions. I've tried
googling with no luck, how do I do it?

Thanks

Lyle

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael A. Peters 2010-07-25 03:48:27 Re: pg_dump, shemas, backup strategy
Previous Message Michael A. Peters 2010-07-25 02:55:39 Re: pg_dump, shemas, backup strategy