Transaction id

[lnd@hnit.is]

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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Jan Wieck]

Re: Transaction id

lnd@hnit.is wrote:
[color=blue]
> 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[/color]

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 #


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings