Re: cannot use column references in default expression?

Поиск
Список
Период
Сортировка
От Jignesh Shah
Тема Re: cannot use column references in default expression?
Дата
Msg-id AANLkTik-dXUVY1YC2WQELlIgLZJ6sYKyta02mx-15QBm@mail.gmail.com
обсуждение исходный текст
Ответ на Re: cannot use column references in default expression?  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы 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>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: cannot use column references in default expression?
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: cannot use column references in default expression?