Skip site navigation (1) Skip section navigation (2)

BUG #2647: Atomicity issues when using rules

From: "" <postgresql_atomicity(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2647: Atomicity issues when using rules
Date: 2006-09-23 17:43:36
Message-ID: 200609231743.k8NHhaDF008345@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2647
Logged by:          
Email address:      postgresql_atomicity(at)yahoo(dot)com
PostgreSQL version: 8.1
Operating system:   Debian GNU/Linux
Description:        Atomicity issues when using rules
Details: 

When I ensure atomicity by locking tables in a transaction, my transactions
still break when I have additional tables touched by rules on tables I
explicitly locked. I can work around by also locking them, but this breaks
modularity of the rules. There should be the policy, or at least the option
when creating the rule of also locking the referenced tables of the rules
automatically when locking the table on which the rule was defined.

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-09-23 17:44:29
Subject: Re: Corruption of multibyte identifiers on UTF-8 locale
Previous:From: Victor SnezhkoDate: 2006-09-23 17:33:47
Subject: Re: Corruption of multibyte identifiers on UTF-8 locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group