Re: [GENERAL] Alter sequence restart with selected value...

2007-09-18 Thread Jeff Ross
Scott Marlowe wrote: On 9/18/07, Jeff Ross <[EMAIL PROTECTED]> 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

Re: [GENERAL] Alter sequence restart with selected value...

2007-09-18 Thread Scott Marlowe
On 9/18/07, Jeff Ross <[EMAIL PROTECTED]> 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 vio

[GENERAL] Alter sequence restart with selected value...

2007-09-18 Thread Jeff Ross
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. Here's the start of the new table creation: CR