Re: [Proposal] Global temporary tables

I am thinking about explicit LOCK statements. Some applications use explicit locking from some reasons - typically as protection against race conditions.

But on GTT race conditions are not possible. So my question is - does the exclusive lock on GTT  protection other sessions do insert into their own instances of the same GTT?

In my opinion, with a GTT, always work on the private data of the session, 

there is no need to do anything by holding the lock, so the lock statement should do nothing (The same is true for ORACLE GTT)

What do you think?

What is a level where table locks are active? shared part of GTT or session instance part of GTT?

I don't quite understand what you mean, could you explain it a little bit?

Wenjing

Wenjing

Now, table locks are implemented on a global level. So exclusive lock on GTT in one session block insertion on the second session. Is it expected behaviour? It is safe, but maybe it is too strict.

We should define what table lock is meaning on GTT.

Regards

Pavel

 

Pavel

With Regards,
Prabhat Kumar Sahu
EnterpriseDB: http://www.enterprisedb.com