| 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: | Whole Thread | Raw Message | 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? :-)
| 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? |