Search Postgresql Archives

Re: Class dependencies

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux