Re: Changing ids conflicting with serial values?

[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.