Trigger problem, record "new" is not assigned yet

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger problem, record "new" is not assigned yet
Date: 2011-02-10 14:29:58
Message-ID: AANLkTimJMN5XPU3bKK-SWy--J-3DSFTiQqSGKQQLgNJY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

I'm probably doing some very basic error here, but I get

ERROR: record "new" is not assigned yet
The tuple structure of a not-yet-assigned record is indeterminate.

when I try this small example

create table foo(x int);

create or replace function trigger_foo() returns trigger language plpgsql as $$
declare v_i integer;
begin
select count(1) into v_i from foo;
if new.x >18 then
raise exception 'error';
else
return null;
end if;
end; $$;

CREATE TRIGGER trigger_foo AFTER INSERT ON foo for each row EXECUTE
PROCEDURE trigger_foo();

insert into foo (x) values (15);

And the table foo only have 14 lines right now.

Can someone help me spot the error? :-)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2011-02-10 14:33:56 Re: Trigger problem, record "new" is not assigned yet
Previous Message Adrian Klaver 2011-02-10 14:27:32 Re: Backup/Restore Needed for Upgrade from 9.0beta4?