Re: [GENERAL] How to safely compare transaction id?

2008-01-13 Thread alphax
Tom Lane wrote: > alphax <[EMAIL PROTECTED]> writes: >> So, it seems the system column "cmin" is the logical "current version" >> of that record, isn't it? > > No. Have you read > http://www.postgresql.org/docs/8.2/static/ddl-system-colu

Re: [GENERAL] How to safely compare transaction id?

2008-01-13 Thread alphax
Marko Kreen wroted: By the way, Can I think that the value of system column "ctid" of an record is the logical "current version" of that record, and used to compare with txid returned by "FUNCTIONS-TXID-SNAPSHOT"? No, it is just physical location of the row. Thanks, I just done some sim

Re: [GENERAL] How to safely compare transaction id?

2008-01-11 Thread alphax
Marko Kreen wrote: > On 1/11/08, alphax <[EMAIL PROTECTED]> wrote: >> I want to compare the record's transaction id in sql statements or >> PL/pgSQL stored procedure. Are there any system function or operator can >> safely(transaction id wraparound safed) compar

[GENERAL] How to safely compare transaction id?

2008-01-11 Thread alphax
Hi, I want to compare the record's transaction id in sql statements or PL/pgSQL stored procedure. Are there any system function or operator can safely(transaction id wraparound safed) compare the transaction id? Thanks! ---(end of broadcast)--- T