On Thursday, February 10, 2011 6:29:58 am A B wrote:
> 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? :-)

The above works here, Postgres 9.0.3. Was that the complete error message? Is 
there more than one foo across the schemas?


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to