| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Tarlika Elisabeth Schmitz <postgresql4(at)numerixtechnology(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: unique across two tables |
| Date: | 2011-06-20 17:42:20 |
| Message-ID: | A510C5B4-939B-4D19-8405-AE93C6BCCE9F@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 20 Jun 2011, at 17:03, Tarlika Elisabeth Schmitz wrote:
> I have two tables, town and townalias, the latter containing alternative
> town names.
> I would like to ensure that a town name is unique per
> country-region across the two tables.
>
> Can I do this with a constraint ot do I need to implement the logic via
> trigger?
This is very similar to what was recently discussed in the topic "Constraint to ensure value does NOT exist in another table?" in this list.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4dff868612099297279502!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hyelluas | 2011-06-20 18:10:33 | Re: how to find a tablespace for the table? |
| Previous Message | Alexander Farber | 2011-06-20 17:34:46 | Re: PostgreSQL 8.4.8 bringing my website down every evening |