Postgres Pro
Downloads
Home   >   mailing lists

Re: CTID: Anyway to lock it? - Mailing list pgsql-odbc

From Tom Lane
Subject Re: CTID: Anyway to lock it?
Date
Msg-id 29773.1036438399@sss.pgh.pa.us
Whole thread Raw
In response to CTID: Anyway to lock it?  (Jim Hines <jhines@wdtv.com>)
List pgsql-odbc
Tree view 
Jim Hines <jhines@wdtv.com> writes:
> Apparently the CTID changes per record with each update. Is there anyway to
> lock the CTID so that it doesn't change everytime I update a record?

No.  If your software is using CTID as a long-term (more than one
transaction) record identifier, then your software is broken.

            regards, tom lane

pgsql-odbc by date:

Previous
From: Jim Hines
Date:
Subject: CTID: Anyway to lock it?
Next
From: "Dave Page"
Date:
Subject: Re: CTID: Anyway to lock it?