Search Postgresql Archives

Re: Changing ids conflicting with serial values?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux