Re: cannot use column references in default expression?

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: cannot use column references in default expression?
Date: 2010-05-28 17:41:02
Message-ID: AANLkTik-dXUVY1YC2WQELlIgLZJ6sYKyta02mx-15QBm@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postnewspapers(dot)com(dot)au>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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2010-05-28 17:47:59 Re: cannot use column references in default expression?
Previous Message Craig Ringer 2010-05-28 17:30:59 Re: cannot use column references in default expression?