Re: Does Postgres support bookmarks (tuples ids)?

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does Postgres support bookmarks (tuples ids)?
Date: 2010-12-01 14:55:04
Message-ID: AANLkTinSAe9=+hM1nt174V-Oh89BHQORauWY4-VJ630h@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 1, 2010 at 12:57 AM, Dann Corbit <DCorbit(at)connx(dot)com> wrote:
> The ctid is not permanent.   An alternative is to create tables with OID
> values.

Creating OIDs gives you zero benefit over having a PK. They would be
roughly equivalent if you added a unique index on the OID column, but
that is by no means automatic.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-12-01 14:58:21 Re: Cannot start Postgres- FATAL: invalid cache id: 19
Previous Message Jolles, Peter M (GE Energy) 2010-12-01 14:20:34 Cannot start Postgres- FATAL: invalid cache id: 19