Re: cannot use column references in default expression? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: cannot use column references in default expression?
Date
Msg-id 4C00026B.10300@gmail.com
Whole thread Raw
In response to Re: cannot use column references in default expression?  (Jignesh Shah <jignesh.shah1980@gmail.com>)
List pgsql-general
On 05/28/2010 10:41 AM, Jignesh Shah wrote:
> 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@postnewspapers.com.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
>>
>

What previous version? I just tried 8.3.5 and it did not work there either.

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: cannot use column references in default expression?
Next
From: Nilesh Govindarajan
Date:
Subject: Re: cannot use column references in default expression?