Dave Cramer <[EMAIL PROTECTED]> writes: > Do the transaction id's used in 2PC need to be unique across all > sessions? > Do we provide a mechanism for this ? > If not shouldn't we provide a way to create a unique transaction id ?
I see no value in that at all. The point of 2PC is to synchronize with other databases running other transactions; an ID assigned by one database that can only be guaranteed unique with respect to that database is really pretty useless. In practice the IDs will be assigned by the transaction manager module according to its own needs. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq