Postgres Pro
Downloads
Home   >   mailing lists

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

From Jignesh Shah
Subject Re: cannot use column references in default expression?
Date
Msg-id AANLkTik-dXUVY1YC2WQELlIgLZJ6sYKyta02mx-15QBm@mail.gmail.com
Whole thread Raw
In response to Re: cannot use column references in default expression?  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: cannot use column references in default expression?  (Christophe Pettus <xof@thebuild.com>)
Re: cannot use column references in default expression?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

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