Re: [HACKERS] [GENERAL] How to enumerate foreign key constraints after migrating from 7.1.3?

2003-06-11 Thread Forest Wilkinson
Rod Taylor [EMAIL PROTECTED] wrote: Unfortunately, having all my users run contrib/adddepend isn't an option for me. However, that script does contain a good deal of information that I may be able to use for detecting old-style foreign key constraints in my own code. I assume you're doing

Re: [HACKERS] [GENERAL] How to enumerate foreign key constraints after

2003-06-11 Thread Rod Taylor
Yes, a combination of the two would probably be better. You would need to be careful about function call names for FKeys, there are a fair number of them. Checking for 3 triggers with the function name starting with RI_FKey* would probably be better. Will the tgisconstraint flag always be

Re: [HACKERS] [GENERAL] How to enumerate foreign key constraints after

2003-06-10 Thread Rod Taylor
Moving to -hackers. Unfortunately, having all my users run contrib/adddepend isn't an option for me. However, that script does contain a good deal of information that I may be able to use for detecting old-style foreign key constraints in my own code. I assume you're doing the database

Re: [HACKERS] [GENERAL] How to enumerate foreign key constraints after

2003-06-10 Thread Alvaro Herrera
On Tue, Jun 10, 2003 at 10:25:05PM -0400, Rod Taylor wrote: I see that adddepend detects old-style foreign key constraints by looking for groups of 3 triggers having 6 or more identical function arguments. Is that the best way to do it? That said, I've not heard of any issues with the