Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Foreign Unique Constraint
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: pgsql-sql(at)postgresql(dot)org
- Cc: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>, "'Jon Horsman'" <horshaq(at)gmail(dot)com>
- Subject: Re: Foreign Unique Constraint
- Date: Wed, 28 Mar 2007 11:08:07 +0200
Am Mittwoch, 28. März 2007 00:17 schrieb Phillip Smith: > Perhaps this...? It would work, but depending how many rows are in the > table, it could become incredibly slow. > > ALTER TABLE table1 ADD CHECK (extension NOT IN (SELECT extension FROM > table2)); Subqueries are not allowed in check constraints. -- Peter Eisentraut http://developer.postgresql.org/~petere/
- Follow-Ups:
- Re: Foreign Unique Constraint
- From: Phillip Smith
- Re: Foreign Unique Constraint
- From: Jon Horsman
- Re: Foreign Unique Constraint
- References:
- Re: Foreign Unique Constraint
- From: Phillip Smith
- Re: Foreign Unique Constraint
- Prev by Date: Re: Foreign Unique Constraint
- Next by Date: Re: Regular Expressions [progress]
- Previous by thread: Re: Foreign Unique Constraint
- Next by thread: Re: Foreign Unique Constraint
- Indexes: