Insert into ... Select ... From ... too intelligent transaction

Hi all,

I'm still working on my updateable views, which work fine now even I have a trigger to use because my delete rules wont work, but thats not my current, more important problem.

I use some updateable views to handle my data (which are amazingly slow), which gives me ultimate flexibility to handle my data.

there are some insert rules which use currval() to get the last sequence id for my data which I have to insert.

The problem now is, it works fine if I do the statement via normal insert into satatements, even within a transaction block. So far so good. But If I migrate my old data via **Insert into my_new_view Select ... From my_old_table**, Only the last retrieved value of the sequences is used which blows my whole internal logic, because obviously I want to use the current (for that row) and not the last id.

For me it seems that the optimizer optimizes a bit to much!

Is the an easy workaround?

Many thanks for any help
Jürgen