Postgres Pro
Downloads
Home   >   mailing lists

Re: Rowtype column and domain subfield with DEFAULT and NOT NULL constraint - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Rowtype column and domain subfield with DEFAULT and NOT NULL constraint
Date
Msg-id CAB7nPqRyBLcjqiHKDvaRyCsCSDV2m+rynJThaqXvETA-fx5BMw@mail.gmail.com
Whole thread Raw
In response to Re: Rowtype column and domain subfield with DEFAULT and NOT NULL constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Wed, Mar 12, 2014 at 11:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Julien Tachoires <julien.tachoires@dalibo.com> writes:
>> A customer has reported us a strange behaviour regarding a rowtype
>> column with a domain subfield:
>
> Rowtypes in general do not support defaults for component fields.
And what about adding a TODO item?
Support default values for component fields of rowtypes

We could as well for the time being improve the documentation to
mention that with some examples. For example with some more content on
the page of INSERT.
Regards,
-- 
Michael

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Replication slots and footguns
Next
From: Christian Kruse
Date:
Subject: Re: Patch: Show process IDs of processes holding a lock; show relation and tuple infos of a lock to acquire