Re: lifetime of the old CTID

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: lifetime of the old CTID
Date: 2022-07-06 17:45:39
Message-ID: YsXKQ3kFpb6CiDkG@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-07-06 18:50:26 Re: Seems to be impossible to set a NULL search_path
Previous Message David G. Johnston 2022-07-06 17:25:29 Re: Seems to be impossible to set a NULL search_path