On 2011-01-10, Joel Jacobson <joel@xxxxxxxxxxxxxxx> wrote: > Hi, > > 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? > > I'm looking at http://developer.postgresql.org/pgdocs/postgres/catalogs.html > > For each class, a list of "References" are defined, i.e. other classes > the given class depend on. > 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. table a (b,c) references d(e,f) requires unique (e,f) on table d -- ââ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general