-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of erhaminus Sent: Wednesday, October 19, 2011 10:33 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general