| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com> |
| Cc: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: cannot use column references in default expression? |
| Date: | 2010-05-28 17:50:35 |
| Message-ID: | 4C00026B.10300@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
> <craig(at)postnewspapers(dot)com(dot)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
>>
>
What previous version? I just tried 8.3.5 and it did not work there either.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | erobles | 2010-05-28 18:20:56 | there is a way to deactivate type validation on 8.3.1???? |
| Previous Message | Christophe Pettus | 2010-05-28 17:47:59 | Re: cannot use column references in default expression? |