Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transaction Behavior

Status
Not open for further replies.
milner

milner

Programmer
Apr 15, 1999
28
CA
Hi,

This doesn't necessaryily apply to pgsql, but, her goes anyway.

If I have a table and I begin a transaction and add 1000 records before committing. During this time, a second user accesses the same table. Will they see any of the records that I'm adding? Or will the records not show up until the commit is performed?
 
Sort by date Sort by votes
AFAIA the transaction will be committed in a burst so they won't see them unitl it commits.

from the mists of uni i seem to remember something about pessimistic and optimistic locking so it might be worth looking up those terms on google ...

Steve
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wengyan
  • Locked
  • Question
How about begin a transaction
Replies
1
Views
40
ceco
ceco
amiracam
  • Locked
  • Question
Functions and Transactions , need workaround
Replies
2
Views
54
ConradIrwin
ConradIrwin
pgosse
  • Locked
  • Question
Unknown error from Transactions
Replies
0
Views
37
pgosse
pgosse

Part and Inventory Search

Sponsor

Back
Top