The following bug has been logged online:
Bug reference: 1507
Logged by: Alexis Wilke
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Linux (not relevant)
Description: CREATE RULE commands atomicity
Details:
I read the page about CREATE RULE and Chapter 33 which explains the rules
and I couldn't find anything about whether rules are atomically executed
(i.e. is there an implied BEGIN/COMMIT?)
My point here is if I write one INSERT command somewhere which is
transformed by a rule, I'm very likely
not going to write BEGIN + COMMIT since to me it will look like one
instruction and I expect it to be
atomic by itself.
Is that a correct assumption?!
Thank you.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
