Re: [GENERAL] unique constraint when updating tables

2006-08-22 Thread Martijn van Oosterhout
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 go

Re: [GENERAL] unique constraint when updating tables

2006-08-22 Thread A. Kretschmer
am Tue, dem 22.08.2006, um 8:39:00 +0800 mailte gao iqiang folgendes: > 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 10

[GENERAL] unique constraint when updating tables

2006-08-22 Thread gao iqiang
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 10