another glance at source code, and docs tells me - that there's not such thing as default value for custom type - unless that type is defined as new base scalar type. So probably, that would require postgresql to allow users to define default values for composite types as well, like that: create type foo AS ( a int default 1, b foodomain default 'foo', .... ); Going through source code, I have no idea where that would go - because I got only experience in creating types + custom indices, not hacking postgresql guts. More help required here, please .. (I don't know, should that go to -hackers [too]. My recent history there probably makes majority of folks to ignore my posts straight away). Thanks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
