-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of erhaminus
Sent: Wednesday, October 19, 2011 10:33 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Composite type, DEFAULT, NOT NULL, REFERENCES
Hi,
Is a way to define DEFAULT, NOT NULL and REFERENCES for members of composite type?
--------------------/Original Message---------------
The only way to constrain a Type is to use a DOMAIN but whether you can domain a composite type I do not know.
There is no concept of "Foreign Key" when it comes to Types, only Tables.
David J.