Re: Foreign key modification - Mailing list pgadmin-hackers

From Jean-Michel POURE
Subject Re: Foreign key modification
Date
Msg-id 4.2.2.20010927100429.00ad0c20@192.168.3.249
Whole thread Raw
In response to Foreign key modification  (Jean-Michel POURE <jmpoure@axitrad.com>)
List pgadmin-hackers
>Can't you pick an easier one to start with?!?! Foreign Keys are probably the
>most complex bit of pgSchema...
>
>In the simplest terms, pgSchema will need Remove & Add methods in
>ForeignKeys.cls. These will drop/re-create the three triggers that make up
>the Foreign Key (I assume there is nothing more to an fkey, I've certainly
>never found anything).
>
>If you wish to edit an fkey, you will need to make the relevant property of
>pgForeignKey.cls read/write and add the code to the Property Let to drop &
>recreate the relevant trigger in the required way.
>
>I would take a look at how ForeignKeys.cls analyses the existing triggers to
>figure out what the triggers look like and how to best modify them.
>
>Regards, Dave.

Hello Dave,

Ok, I though pgSchema already had these features.
I will have a look at this Remove & Add methods in ForeignKeys.cls.

Cheers,
Jean-Michel


pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Foreign key modification
Next
From: Dave Page
Date:
Subject: Re: Foreign key modification