dbTalk Databases Forums  

[BUGS] BUG #1140: Auto-increment and Rollback

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1140: Auto-increment and Rollback in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PostgreSQL Bugs List
 
Posts: n/a

Default [BUGS] BUG #1140: Auto-increment and Rollback - 04-19-2004 , 06:18 PM







The following bug has been logged online:

Bug reference: 1140
Logged by: Emil Tarazi

Email address: emil (AT) cmu (DOT) edu

PostgreSQL version: 7.4

Operating system: Linux

Description: Auto-increment and Rollback

Details:

If a query is called within a BEGIN-COMMIT/ROLLBACK block that
auto-increments some field, a ROLLBACK will not decrement that field.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #2  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: [BUGS] BUG #1140: Auto-increment and Rollback - 04-19-2004 , 06:31 PM






PostgreSQL Bugs List wrote:
Quote:
The following bug has been logged online:

Bug reference: 1140
Logged by: Emil Tarazi

Email address: emil (AT) cmu (DOT) edu

PostgreSQL version: 7.4

Operating system: Linux

Description: Auto-increment and Rollback

Details:

If a query is called within a BEGIN-COMMIT/ROLLBACK block that
auto-increments some field, a ROLLBACK will not decrement that field.
Read the FAQ.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.