| 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 |