Re: default values in inheritance hierarchies

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Miroslav Šimulčík <simulcik(dot)miro(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: default values in inheritance hierarchies
Date: 2012-02-27 22:51:49
Message-ID: 20863.1330383109@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?ISO-8859-2?Q?Miroslav_=A9imul=E8=EDk?= <simulcik(dot)miro(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2012-02-27 23:02:24 Re: Trigger execution role (was: Triggers with DO functionality)
Previous Message Christopher Browne 2012-02-27 22:49:18 Re: leakproof