dbTalk Databases Forums  

txid_current() and dump/restore

comp.databases.postgresql comp.databases.postgresql


Discuss txid_current() and dump/restore in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Guettler
 
Posts: n/a

Default txid_current() and dump/restore - 02-11-2008 , 10:10 AM






Hi,

from: http://www.postgresql.org/docs/8.3/i...ions-info.html

'''
txid_current() bigint get current transaction ID
The internal transaction ID type (xid) is 32 bits wide and so it wraps around every 4 billion transactions. However,
these functions export a 64-bit format that is extended with an "epoch" counter so that it will not wrap around for the
life of an installation.
'''

What does 'epoch' counter mean? Seconds since 1970?

If you dump a table which stores values from txid_current() and restore them
in a new database, is possible that new ids will be duplicate?

Thomas

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.