[snip]
On Thu, 2005-11-03 at 18:02, SCassidy@overlandstorage.com wrote:
> Strange - I had never realized that PostgreSQL would allow you to UPDATE a
> primary key value. I thought that other db's I had used (e.g. Sybase,
> Oracle, SQL Server, etc.) in the past would not allow that, and you had to
> DELETE, then INSERT to modify a row that needed a different primary key.
Well, you're wrong about that too... Oracle at least will definitely let
you update a primary key. The primary key is technically nothing more
than a unique, not null restriction, plus an index on it, otherwise you
can do with it what you wish.
> [snip]
Cheers,
Csaba.