Postgres Pro
Downloads
Home   >   mailing lists

Re: Does Postgres support bookmarks (tuples ids)? - Mailing list pgsql-general

From Vick Khera
Subject Re: Does Postgres support bookmarks (tuples ids)?
Date
Msg-id AANLkTinSAe9=+hM1nt174V-Oh89BHQORauWY4-VJ630h@mail.gmail.com
Whole thread Raw
In response to Re: Does Postgres support bookmarks (tuples ids)?  (Dann Corbit <DCorbit@connx.com>)
Responses Re: Does Postgres support bookmarks (tuples ids)?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
On Wed, Dec 1, 2010 at 12:57 AM, Dann Corbit <DCorbit@connx.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.

pgsql-general by date:

Previous
From: "Jolles, Peter M (GE Energy)"
Date:
Subject: Cannot start Postgres- FATAL: invalid cache id: 19
Next
From: Vick Khera
Date:
Subject: Re: Cannot start Postgres- FATAL: invalid cache id: 19