Re: Separate Sessions?? (View data <-> Query tool)

>The problem is that my triggers refuse modifying a record if a given Temp
table is not created before, because one or more fields have their default
values from that temp table

So why don't you either use a normal table, or if you need simultaneous use
of the trigger with different values, use an array instead of a table. Or
you might create the temp table in the trigger function..
If you create a normal table you can still delete it afterwards.

hth
WBL
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw