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

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: [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

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 u