Re: pg_depend explained - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_depend explained
Date
Msg-id 1294837502-sup-1771@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_depend explained  (Joel Jacobson <joel@gluefinance.com>)
Responses Re: pg_depend explained  (Joel Jacobson <joel@gluefinance.com>)
List pgsql-hackers
Excerpts from Joel Jacobson's message of mié ene 12 07:07:35 -0300 2011:

> The automatically created objects, such as primary key indexes,
> constraints and triggers, have been ignored in this graph, as they are
> implicitly created when creating the "base objects".

FWIW this idea fails when you consider stuff such as circular foreign
keys (and I suppose there are other, more common cases).  If you really
want something general you need to break those apart.  (This is the
explanation for the “break the loop” code in pg_dump I imagine)

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Dan Ports
Date:
Subject: Re: SSI and 2PC
Next
From: Alexey Klyukin
Date:
Subject: Re: arrays as pl/perl input arguments [PATCH]