Horton

Re: lifetime of the old CTID

Karsten Hilbert <karsten.hilbert@gmx.net>

View thread View on postgr.es
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@lists.postgresql.org
Date: 2022-07-06T17:45:39Z
Lists: pgsql-general 
> Said this, we can end this thread. Re-think the data model is not an
> option.

Why not ?

	- add a primary key to each table, say db01buch.pk
	- rename tables, say db01buch -> db01buch__real_table
	- add views, say db01buch over db1buch__real_table with "pk AS ctid"

(untested, however)

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B