Postgres Pro
Downloads
Home   >   mailing lists

Constraint to ensure value does NOT exist in another table? - Mailing list pgsql-general

From Mike Christensen
Subject Constraint to ensure value does NOT exist in another table?
Date
Msg-id BANLkTineoT4gKz8vybDQJarVhtxSf-84-g@mail.gmail.com
Whole thread Raw
Responses Re: Constraint to ensure value does NOT exist in another table?
Re: Constraint to ensure value does NOT exist in another table?
Re: Constraint to ensure value does NOT exist in another table?
List pgsql-general
Tree view 
I know I can setup a FK constraint to make sure Table1.ColA exists in
Table2.Key, however what if I want to do the reverse?

I want to ensure Table1.ColA does NOT exist in Table2.Key..  Can I do
this with any sort of CHECK constraint, trigger, custom function, etc?
 Thanks!

Mike

pgsql-general by date:

Previous
From: Vikram A
Date:
Subject: Re: PGP encrypt/decrypt - Prereqistes
Next
From: Mike Christensen
Date:
Subject: Re: You could be a PostgreSQL Patch Reviewer!