Scott Marlowe wrote:
On 9/18/07, Jeff Ross <jross@xxxxxxxxxx> wrote:
I'm using copy to insert a bunch of rows into a new table with a unique
primary key. Copy is correctly incrementing the primary key, but
apparently the sequence itself is never updated because when I go to
insert again I get a constraint violation.
Try using setval.
select setval('seqname',select max(id) from tablename));
!DSPAM:46eff995184363531088756!
Oh, I knew it was going to be something simple!
Than you, Scott.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
