The function: CREATE OR REPLACE FUNCTION dropfk() RETURNS integer AS $BODY$ DECLARE isDropped INTEGER; BEGIN IF exists(select 1 from pg_constraint where conname = 'my_fk') THEN ALTER TABLE my_table DROP CONSTRAINT my_fk CASCADE; isDropped = 1; ELSE isDropped = 0; END IF; return isDropped; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; ALTER FUNCTION dropfk() OWNER TO postgres; W dniu 20 kwietnia 2011 13:02 uÅytkownik Viktor BojoviÄ <viktor.bojovic@xxxxxxxxx> napisaÅ: > use this table: > http://www.postgresql.org/docs/8.3/static/catalog-pg-constraint.html > to check if it exists. > On Wed, Apr 20, 2011 at 12:46 PM, Lukasz Brodziak > <lukasz.brodziak@xxxxxxxxx> 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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin > > > > -- > --------------------------------------- > Viktor BojoviÄ > --------------------------------------- > Wherever I go, Murphy goes with me > -- Å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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
