Re: cannot use column references in default expression?

[Jignesh Shah <jignesh.shah1980@xxxxxxxxx>]

Trigger should be the last solution. This used to be working but I think with latest postgresql upgrade, this stopped working. Might be someone around here knows whats going on here.

Thanks,
Jignesh

On Fri, May 28, 2010 at 11:00 PM, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote:

On 29/05/2010 1:20 AM, Jignesh Shah wrote:

Could anyone please help me to get rid of following error? I want to set
the 'ishuman' column based on the value of 'ID' column but it is not
allowing me to do so. Any alternatives?

Use a BEFORE trigger to set it.

--
Craig Ringer