From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>, "Alan Hodgson" <ahodgson(at)simkin(dot)ca>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Trouble with NEW |
Date: | 2012-07-19 06:53:29 |
Message-ID: | AE3B3277-15AE-4888-8FDE-411ED86377FB@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 19 Jul 2012, at 24:20, Bob Pawley wrote:
> When I substitute new.fluid_id for the actual fluid)id the expression returns the right value.
>
> Following is the table -
>
> CREATE TABLE p_id.fluids
> (
> p_id_id integer,
> fluid_id serial,
I think people meant the one on which the trigger fires ;)
This one can't (shouldn't) be it, or you would introduce in an infinite loop by calling update on the same table.
> On 07/18/2012 12:28 PM, Bob Pawley wrote:
>> It's an insert after trigger function.
>>
>> The table has a column named fluid_id.
>
> Can we see the table schema. What I am looking for is quoted column name
> that would preserve case.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Law | 2012-07-19 07:23:39 | Re: main log encoding problem |
Previous Message | Alexander Law | 2012-07-19 06:37:49 | Re: main log encoding problem |