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.