X-Original-To: pgsql-novice@postgresql.org Received: from web41112.mail.yahoo.com (web41112.mail.yahoo.com [66.218.93.28]) by postgresql.org (Postfix) with SMTP id 05FFB475FEE for ; Wed, 12 Mar 2003 02:21:22 -0500 (EST) Message-ID: <20030312072122.12363.qmail@web41112.mail.yahoo.com> Received: from [202.141.236.106] by web41112.mail.yahoo.com via HTTP; Wed, 12 Mar 2003 07:21:22 GMT Date: Wed, 12 Mar 2003 07:21:22 +0000 (GMT) From: =?iso-8859-1?q?Muhammad=20Shariq=20Muzaffar?= Subject: SERIAL does not ROLLBACK To: pgsql-sql@postgresql.org Cc: pgsql-novice@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200303/81 X-Sequence-Number: 6394 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