Re: Class dependencies - Mailing list pgsql-general

From Tom Lane
Subject Re: Class dependencies
Date
Msg-id 24042.1294667430@sss.pgh.pa.us
Whole thread Raw
In response to Re: Class dependencies  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
Jasen Betts <jasen@xnet.co.nz> writes:
> On 2011-01-10, Joel Jacobson <joel@gluefinance.com> wrote:
>> Is it safe to assume all objects of a given class can be
>> dropped/created, provided all objects of a list of other classes have
>> already been dropped/created?

>> For instance, is it correct to assume constraints always can be
>> dropped, i.e. no other class (nor other constraints) can depend on
>> them?

> As I unserstand it a references constraint requires a unique
> constraint on the referred-to expressiom.

Another problem for this type of scheme is circular dependencies.
There are for example circular dependencies between a type and its
I/O functions.  pg_dump contains some heuristics for resolving the
kinds of circular dependencies that are known to exist.

            regards, tom lane

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Class dependencies
Next
From: Vick Khera
Date:
Subject: Re: Realtime Query Dashboard Results