Re: Dropping foreign key only if it exists - Mailing list pgsql-admin

From Viktor Bojović
Subject Re: Dropping foreign key only if it exists
Date
Msg-id BANLkTikxfjGFkvcHztReC-dsbzJv542NwQ@mail.gmail.com
Whole thread Raw
In response to Dropping foreign key only if it exists  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Responses Re: Dropping foreign key only if it exists  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
List pgsql-admin
use this table:
to check if it exists.

On Wed, Apr 20, 2011 at 12:46 PM, Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote:
Hello,

Is there a way of dropping a FK only if it exists. The thing is that I
don't know if client has this FK on the table or not.

--
Łukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if You could look right through the cracks
Would You find Yourself...... Find Yourself afraid to see"

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



--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

pgsql-admin by date:

Previous
From: Lukasz Brodziak
Date:
Subject: Dropping foreign key only if it exists
Next
From: Lukasz Brodziak
Date:
Subject: Re: Dropping foreign key only if it exists