Re: Foreign key modification

>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