Postgres Pro
Downloads
Home   >   mailing lists

Re: lifetime of the old CTID - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: lifetime of the old CTID
Date
Msg-id YsXKQ3kFpb6CiDkG@hermes.hilbert.loc
Whole thread Raw
In response to Re: lifetime of the old CTID  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Seems to be impossible to set a NULL search_path
Next
From: Bryn Llewellyn
Date:
Subject: Re: Seems to be impossible to set a NULL search_path