postgreSQL migration problem...

FROM MSSQL to PostGreSQL...

I am trying to create an INSTEAD OF RULE on a view, to put data in my table. But I cannot use variables inside the RULE. Any variable to assign...

Thanks guys,

I'll have a look!

Will give feedback!

S

I'm running W2000 and XP

Thanks, will have a look

If you have any information before I subscribe I would appreciate!

Thanks, but that doesn't work.

SOS

don't know if i'm right, a trigger only works one line at a time? that's why i use the cursor to insert each record seperatly so that the trigger fires...

ok, my application dynamically builds the views over one big table. i cannot change this, because, everytime i recompile i will loose all data if i don't use views. 2....

exactly what do you need? i checked out the two links and there's a lot of unneccesary stuff in there. can you give me an example? do you want exact...

if you right click on the package and select 'schedule package', THAT doesn't work.

I saw on SQL HELP how to run a dts through a JOB, but that doesn't work...