SERIAL does not ROLLBACK - Mailing list pgsql-sql

From Muhammad Shariq Muzaffar
Subject SERIAL does not ROLLBACK
Date
Msg-id 20030312072122.12363.qmail@web41112.mail.yahoo.com
Whole thread Raw
Responses Re: SERIAL does not ROLLBACK
List pgsql-sql
hi
i have a table named 'mytable' with a column of type
serial. After inserting tuples in a transaction, when
i rollback the transaction the serial number does not
come back to its original value and next time when i
insert the data, it start with the incremented value.
WHY?? how can i make it to come back to its orignial
value in case of rollback.

thanx in advance...

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

pgsql-sql by date:

Previous
From: "Victor Yegorov"
Date:
Subject: Re: Special characters in SQL queries
Next
From: Stephan Szabo
Date:
Subject: Re: SERIAL does not ROLLBACK