Postgres Pro
Downloads
Home   >   mailing lists

Re: Using CTID system column as a "temporary" primary key - Mailing list pgsql-general

From Maciek Sakrejda
Subject Re: Using CTID system column as a "temporary" primary key
Date
Msg-id CAOtHd0B8RihPwaE7_iO0JSe4utk=DJZ31ivic6+R7XP3E3dFUg@mail.gmail.com
Whole thread Raw
In response to Re: Using CTID system column as a "temporary" primary key  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
List pgsql-general
Tree view
Note that VACUUM FULL and CLUSTER can update ctids. I don't believe regular VACUUM can, so you should be safe from autovacuum interfering in this scheme, but the ctid colum documentation [1] states "A primary key should be used to identify logical rows," so this is not exactly intended usage.

Thanks,
Maciek

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Cluster table based on grand parent?
Next
From: Rob Sargent
Date:
Subject: Re: Cluster table based on grand parent?