On Tue, Aug 25, 2009 at 12:07:44PM +0000, Fernando Velloso Tanure wrote: > > The following bug has been logged online: > > Bug reference: 5009 > Logged by: Fernando Velloso Tanure > Email address: f_tan...@terra.com.br > PostgreSQL version: 8.1.11 > Operating system: CentOS5.3 Red Hat Enterprise Linux RHEL > Description: Loss of information > Details: > > Good afternoon > > I'm having problem in postgres where some rows inserted or changed > during the day was lost as a rollback was executed.
That is rollback's defined behavior in every database management system, not just PostgreSQL. > I am using a system developed in Delphi with Zeos components for > access to the database. > > The sequences used in the inserts are not lost. This, too, is defined behavior. Sequences provide uniqueness, and only that. If you wish to create some entity which has some other properties, be aware that such entities require locking, which sharply limits their speed. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
