Antw: [SQL] Rollback & Nextval fails

Fredrik Eriksson wrote: > I have been trying the following SQL code : > BEGIN; > INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' ); > ROLLBACK; > And the insert function is rolled back but the serial sequence isn't. Hav I > misunderstood the functionality of rollback or is this a bug? Is

Re: [SQL] Rollback & Nextval fails

Fredrik, > I have been trying the following SQL code : > > BEGIN; > INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' ); > ROLLBACK; > > And the insert function is rolled back but the serial sequence isn't. Hav I > misunderstood the functionality of rollback or is this a bug? Is there > somew

[SQL] Rollback & Nextval fails

I have been trying the following SQL code : BEGIN; INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' ); ROLLBACK; And the insert function is rolled back but the serial sequence isn't. Hav I misunderstood the functionality of rollback or is this a bug? Is there someway to get the functionality