-----Original Message-----
From: pgsql-general-ow...@postgresql.org 
[mailto:pgsql-general-ow...@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.



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to