> Aha! So it's likely that by listing the PK column name in the list of > columns to be inserted was what caused the problem? No need to specify > DEFAULT for it? > There's no need to specify the column if it has a default value, but specifying it did not cause the issue that you saw.
- Reset sequence to current maximum value of rows Rich Shepard
- Re: Reset sequence to current maximum value of rows Ron Johnson
- Re: Reset sequence to current maximum value of ... Rich Shepard
- Re: Reset sequence to current maximum value... Ron Johnson
- Re: Reset sequence to current maximum v... Rich Shepard
- Re: Reset sequence to current maxi... Jeremy Smith
- Re: Reset sequence to current ... Rich Shepard
- Re: Reset sequence to current maximum value... Adrian Klaver
- Re: Reset sequence to current maximum v... Rich Shepard
- Re: Reset sequence to current maximum value of rows David G. Johnston
- Re: Reset sequence to current maximum value of ... Rich Shepard
- Re: Reset sequence to current maximum value... David G. Johnston
- Re: Reset sequence to current maximum v... Rich Shepard
- Re: Reset sequence to current maxi... David G. Johnston
- Re: Reset sequence to current ... Rich Shepard
- Re: Reset sequence to current maxi... Adrian Klaver