| From: | Reg Me Please <regmeplease(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | CREATE DOMAIN with REFERENCES |
| Date: | 2008-10-17 08:57:30 |
| Message-ID: | 200810171057.30419.regmeplease@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all.
I have a number of tables that are actually dictionaries.
This means that, in order to keep the reference integrity, in a number of
other tables I have FK definitions like these ones:
CREATE TABLE dict1 ( d1 TEXT PRIMARY KEY, ... );
CREATE TABLE user1 ( d1 TEXT NOT NULL REFERENCES dict1 DEFAULT 'value1' );
I am trying to simplify this thing by defining DOMAINs with the proper "NOT
NULL" and "DEFAULT" predicates.
But it seems there's no way to CREATE a DOMAIN with a "REFERENCES ..."
predicate, possibly in the optional CHECK.
At the moment I have solved the issue with a function that CHECKs for the
VALUE being already in the proper dictionary.
But this way I loose the explicit reference integrity.
Is there any better advise for this need?
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2008-10-17 09:31:37 | Re: postgresql on 64-bit windows |
| Previous Message | searchelite | 2008-10-17 07:32:32 | auto insert data every one minute |