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

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Forest Wilkinson <lyris-pg(at)tibit(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] How to enumerate foreign key constraints after
Date: 2003-06-11 03:05:40
Message-ID: 20030611030540.GB14416@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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 current implementation
> of adddepend, which is also used in a few other well used programs.

I used adddepend on a relatively complicated schema with lots of foreign
key constraints and sequences it worked pretty well. It was from 7.1.3
to 7.4devel.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edmund Dengler 2003-06-11 03:18:11 Performance of query (fwd)
Previous Message Rod Taylor 2003-06-11 02:25:05 Re: [GENERAL] How to enumerate foreign key constraints after

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-06-11 03:17:47 Re: Feature freeze date
Previous Message Rod Taylor 2003-06-11 02:25:05 Re: [GENERAL] How to enumerate foreign key constraints after