>> What happens if an INSERT trigger inserts something into another
>> table which also has a sequence ?
>
> Using what, lastval()? The app will get very confused, because it'll
> get the value from the sequence used in the trigger. Using currval
> there is no problem, but you already knew that.
I knew but I forgot since I use an ORM which handles all the mess ;)