[snip] On Thu, 2005-11-03 at 18:02, SCassidy@xxxxxxxxxxxxxxxxxxx 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend