Re: BUG #5009: Loss of information

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_tanure(at)terra(dot)com(dot)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 <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate