Re: Unique transaction ID

From: Robert Osowiecki <robson(at)cavern(dot)pl>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unique transaction ID
Date: 2006-01-04 18:50:59
Message-ID: 43BC1913.9050605@cavern.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jaime Casanova napisał(a):

> it exists a transaction id called XID, you can't get it via sql
>
>though, you need to make a c function and invoke GetTopTransactionId()
>(or GetCurrentTransactionId() in versions prior to 8.0)
>
>
I've read a little about problems with overlapping XID and how they were
resolved. I don't understand everything but it seems that XID could be
decreased after vacuum, could it?

Robson.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2006-01-04 18:51:07 Re: inserting many rows
Previous Message Michelle Konzack 2006-01-04 18:49:30 create summaries and update a second table?