xmin

Started by Ilja Golshteinover 19 years ago2 messagesgeneral
Jump to latest
#1Ilja Golshtein
ilejn@yandex.ru

Hello!

Is it Ok to use xmin column in application programm?

Purpose is obvios: I need to know the record was not changed since
a moment in the past and things like this.
So every UPDATE should somehow change value of the column.

The choice it trigger or xmin.
Which is better (from perfomance, reliability, compartibility,
whatever, point of view)?

Thanks.

--
Best regards
Ilja Golshtein

#2Richard Huxton
dev@archonet.com
In reply to: Ilja Golshtein (#1)
Re: xmin

Ilja Golshtein wrote:

Hello!

Is it Ok to use xmin column in application programm?

Purpose is obvios: I need to know the record was not changed since
a moment in the past and things like this.
So every UPDATE should somehow change value of the column.

The choice it trigger or xmin.
Which is better (from perfomance, reliability, compartibility,
whatever, point of view)?

The only problem with using xmin is that it's not portable. You won't
find it in Mysql/Oracle etc.

--
Richard Huxton
Archonet Ltd