From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | brilliantov(at)byterg(dot)ru, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: NEW in after insert trugger contained incorrect data |
Date: | 2014-11-14 16:09:50 |
Message-ID: | 5466294E.9000906@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/14/2014 07:32 AM, Brilliantov Kirill Vladimirovich wrote:
> Albe Laurenz wrote on 11/14/2014 01:28 PM:
>>
>> You should post the table definition and the whole trigger; the error
>> message seems to refer to things you omitted in your quote.
>>
>> Yours,
>> Laurenz Albe
>>
>
>
Turns out I was not at a sufficient caffeine level previously:(
>
> Trigger update_cpu_load_stat added to table trassa.cpu_load:
> CREATE TRIGGER update_cpu_load_stat_trigger
> AFTER INSERT
> ON trassa.cpu_load_stat
> FOR EACH ROW
> EXECUTE PROCEDURE trassa.update_cpu_load_stat();
Another run through showed that the issue is above. You have declared
the trigger on trassa.cpu_load_stat instead of trassa.cpu_load.
trassa.cpu_load_stat has no value field, hence the error.
>
> Thank you and excuse my big message.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2014-11-14 18:45:52 | Re: Two instances of Postgres with single data directory |
Previous Message | Adrian Klaver | 2014-11-14 16:00:54 | Re: NEW in after insert trugger contained incorrect data |