| From: | Muhammad Shariq Muzaffar <shariq77(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | SERIAL does not ROLLBACK |
| Date: | 2003-03-12 07:21:22 |
| Message-ID: | 20030312072122.12363.qmail@web41112.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | BERG Thomas | 2003-03-12 07:31:40 | Re: SERIAL does not ROLLBACK |
| Previous Message | cristi | 2003-03-12 06:16:33 | Re: export from postgres into dbf |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | BERG Thomas | 2003-03-12 07:31:40 | Re: SERIAL does not ROLLBACK |
| Previous Message | Victor Yegorov | 2003-03-12 06:44:19 | Re: Special characters in SQL queries |