On Tue, Aug 22, 2006 at 08:39:00AM +0800, gao iqiang wrote: > Hello, > I met the following problem when i am using PostgreSQL as a backend > database: > I have a table "tabrel(a int primary key, b int)", and now there are for > example 100 records with column 'a' be from 1 to 100. When i'm going to add > one to each 'a' and intended to get 'a' varing from 2 to 101, i use SQL > query as "update tabrel set a=a+1" , but i got " ERROR: duplicate key > violates unique constraint tabrel_a_key". Yes, PostgreSQL doesn't currently support deferred unique constraints. You can find workarounds in the archives. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
