Re: Trigger problem

On Thu, 6 Dec 2001, mordicus wrote:

> So, if i do
>
> insert into abreviations(smot,mot,abreviation,pays) select
> smot,mot,abreviation,pays from a;
>
> the Trigger is executed for each row ONLY after all rows have been
> inserted, so the
> "   id    := currval(''abr_id'');"
> in my trigger have false value (always the last value after 53000 insert
> ...)

Wouldn't NEW.id give you the value you want rather than mucking with the
sequence value?

> Any way to fire a trigger really when a row is inserted ?

I don't think you can get the triggers to run such that currval would give
you what you want, but I could be wrong.