dbTalk Databases Forums  

dirty reads

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss dirty reads in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Josh Close
 
Posts: n/a

Default dirty reads - 10-14-2004 , 03:30 PM






Is there a way to do "dirty" reads on postgres?

If there is an insert of a million records or so, is there a way to
select from those records before it's committed?

-Josh

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: dirty reads - 10-14-2004 , 03:38 PM






Josh Close wrote:
Quote:
Is there a way to do "dirty" reads on postgres?

If there is an insert of a million records or so, is there a way to
select from those records before it's committed?
By your transaction, sure, by another, no.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.