Unique record Identifier? - Mailing list pgsql-sql

From Chris Ruprecht
Subject Unique record Identifier?
Date
Msg-id 008101c0e945$1bf489c0$5dd26383@corp.compucom.com
Whole thread Raw
Responses Re: Unique record Identifier?  ("Josh Berkus" <josh@agliodbs.com>)
List 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



pgsql-sql by date:

Previous
From: Ian Lance Taylor
Date:
Subject: Re: Case Insensitive Queries
Next
From: Tom Lane
Date:
Subject: Re: Case Insensitive Queries