| 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: | Whole Thread | Raw Message | 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 |