Postgres Pro
Downloads
Home   >   mailing lists

Re: default values in inheritance hierarchies - Mailing list pgsql-hackers

From Tom Lane
Subject Re: default values in inheritance hierarchies
Date
Msg-id 20863.1330383109@sss.pgh.pa.us
Whole thread Raw
In response to Re: default values in inheritance hierarchies  (Miroslav Šimulčík <simulcik.miro@gmail.com>)
List pgsql-hackers
Tree view 
Miroslav Šimulčík <simulcik.miro@gmail.com> writes:
> Is there any way how to force UPDATE to use default value of ID column from
> table a2 when updating rows in this table, without using triggers?

No.  The update is expanded using the default expression applicable to
the table that is named in the update command (ie, the parent).
        regards, tom lane

pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: leakproof
Next
From: "Kevin Grittner"
Date:
Subject: Re: Trigger execution role (was: Triggers with DO functionality)