Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig Ringer
Subject Re: cannot use column references in default expression?
Date
Msg-id 4BFFFDD3.9060708@postnewspapers.com.au
Whole thread Raw
In response to cannot use column references in default expression?  (Jignesh Shah <jignesh.shah1980@gmail.com>)
Responses Re: cannot use column references in default expression?  (Jignesh Shah <jignesh.shah1980@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: INSERTing lots of data
Next
From: Jignesh Shah
Date:
Subject: Re: cannot use column references in default expression?