Re: [GENERAL] sequence behavior - is this correct

2004-10-24 Thread Sim Zacks
That is correct behavior. The sequence value only updates when you use the sequence value. If you put your own data into the sequence field, as you would be doing in a conversion or import, the sequence does not change. To manually change the sequence values, refer to the script I posted on Oct. 1

[GENERAL] sequence behavior - is this correct

2004-10-24 Thread Marek Lewczuk
Hello, I would like to ask if my problem with sequence is a proper behavior or this is a bug (probably not)... I have a table: CREATE TABLE "testtable" ( "serialfield" SERIAL, "someotherfield" TEXT, PRIMARY KEY("serialfield") ) WITH OIDS; After creation of this table, sequence "testtable_se