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

From Jignesh Shah
Subject cannot use column references in default expression?
Date
Msg-id AANLkTik7etizTd5h8sZScZc5er-XRIT-BtEga2kVQvLY@mail.gmail.com
Whole thread Raw
Responses Re: cannot use column references in default expression?  (Craig Ringer <craig@postnewspapers.com.au>)
Re: cannot use column references in default expression?  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-general
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?

techdb=> CREATE TABLE Users (
       ID INTEGER,
       isHuman        BOOLEAN NOT NULL
                      DEFAULT (ID IS NULL)
                      CHECK (isHuman = ID IS NULL),
       Name  VARCHAR NOT NULL);
ERROR:  cannot use column references in default expression
techdb=>

Thanks,
Jignesh

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: No lidbl.so in libpq.so (postgresql 8.4.4)
Next
From: Craig Ringer
Date:
Subject: Re: INSERTing lots of data