From: | Jean-Michel POURE <jmpoure(at)axitrad(dot)com> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Foreign key modification |
Date: | 2001-09-27 08:07:30 |
Message-ID: | 4.2.2.20010927100429.00ad0c20@192.168.3.249 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-09-27 08:12:20 | Re: Foreign key modification |
Previous Message | Dave Page | 2001-09-27 07:59:53 | Re: Foreign key modification |