Re: Ownership of (temp)tables.

In article <4755@krafla.rhi.hi.is> gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson) writes: >I'm having a bit of a problem with temptables. >I'm using temptables for storing of select-results to use further later, >and that works just fine. >BUT, if I want to do two things at the same time that use the same temptable >name, and so start the 4gl program in two windows, I get a conflict between >the temptable(s) since in both cases it gets the same owner name, and that, >the good book says, is not allowed. This can't be the problem -- all temp tables are strictly local to an engine process. That is, even if two independent sessions by the same user create temp tables of the same name, the names are known only by the engine process; they are not inserted into the system catalogs. Are you *sure* that you are creating them as temp tables? > Gaukur. (gaukur@rhi.hi.is) -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "This song is a traditional bluegrass number, in the sense that it's about dead ancestors." - The Austin Lounge Lizards (live, introducing "Grandpa's Hologram")