From: | "Alexis Wilke" <alexis(at)m2osw(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1507: CREATE RULE commands atomicity |
Date: | 2005-02-25 07:10:20 |
Message-ID: | 20050225071020.49907F0B00@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1507
Logged by: Alexis Wilke
Email address: alexis(at)m2osw(dot)com
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Klaus Ita | 2005-02-25 13:52:20 | select clause not according to SQL standard |
Previous Message | Bruce Momjian | 2005-02-25 02:34:33 | Re: BUG #1497: Default permissions allow any user to create objects |