Re: Transaction id - Mailing list pgsql-general

From Jan Wieck
Subject Re: Transaction id
Date
Msg-id 400D6709.1040704@Yahoo.com
Whole thread Raw
In response to Transaction id  (<lnd@hnit.is>)
List pgsql-general
lnd@hnit.is wrote:

> Is it possible to find "system change ID" in SQL or stored procedures?
> By "system change ID" I understand an internal serialized number which could
> be used to serialize all SQL submitted into the database?
>
> Thank you in advance, Laimis

Not sure what you exactly envision here. What affects the serialization
of statements is more the time when their transaction commits, that the
time they are executed. From the point of view of the statement, that
order will be determined in the future, so how do you expect this thing
to work?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Detecting database corruption
Next
From: "Dylan Milks"
Date:
Subject: Accessing template0 tables