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 [email protected]
Whole thread Raw
In response to Re: cannot use column references in default expression?  (Jignesh Shah <[email protected]>)
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
> <[email protected]>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
[email protected]

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?