Unique record Identifier?

From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Unique record Identifier?
Date: 2001-05-30 20:14:17
Message-ID: 008101c0e945$1bf489c0$5dd26383@corp.compucom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I'm busy writing an application using PostGreSQL and PHP, so my db reads are
'stateless' and I don't know at record 'write' time which record I have read
to begin with. The records I have, have an index, most tables do have a
unique index but the index values could get changed during an update. In
order to be able to re-read a record, I would like to use some unique
identifier of that record, like a unique db-wide rec-id. Does this exist in
PostGres and if so, how do I access it?

Best regards,
Chris

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-30 20:45:09 Re: Case Insensitive Queries
Previous Message Ian Lance Taylor 2001-05-30 19:51:03 Re: Case Insensitive Queries