| Lists: | pgsql-patches |
|---|
| From: | "Jonathan M(dot) Gardner" <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Subtransaction documentation |
| Date: | 2004-07-17 19:11:28 |
| Message-ID: | 200407171211.32712.jgardner@jonathangardner.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Attached is a diff for subtransactions. I modified the SQL reference
section and touched on the various commands therein. I didn't mention
anything about cursors or portals, because I bet they will be resolved
before long.
I looked at the tutorial pages and the MVCC pages and I decided that
subtransactions don't really belong in either place. People who want them
will know they need them when they encounter a situation that demands
them. I see them being used mostly in PL/pgSQL type situations.
Maybe some documentation on the internals is warranted - but I don't know
nearly enough on that to do that task.
- --
Jonathan Gardner
jgardner(at)jonathangardner(dot)net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFA+Xngqp6r/MVGlwwRAot7AJ9DBZSk1l0vkSDsaQzYUWe16jKh4wCeJ+AM
njA7/4j/mawBwOLKw8GykxY=
=415C
-----END PGP SIGNATURE-----
| Attachment | Content-Type | Size |
|---|---|---|
| subtransaction.patch | text/x-diff | 7.2 KB |
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "Jonathan M(dot) Gardner" <jgardner(at)jonathangardner(dot)net>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Subtransaction documentation |
| Date: | 2004-07-17 19:19:17 |
| Message-ID: | 200407172119.17547.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
Jonathan M. Gardner wrote:
> Attached is a diff for subtransactions. I modified the SQL reference
> section and touched on the various commands therein. I didn't mention
> anything about cursors or portals, because I bet they will be
> resolved before long.
It looks like you better wait until the syntax is finalized. I believe
it was resolved to switch to the SAVEPOINT syntax scheme, so statements
like "ABORT will only abort the innermost transaction" will likely
become incorrect.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jonathan M(dot) Gardner" <jgardner(at)jonathangardner(dot)net> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Subtransaction documentation |
| Date: | 2004-07-17 19:22:17 |
| Message-ID: | 16232.1090092137@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
"Jonathan M. Gardner" <jgardner(at)jonathangardner(dot)net> writes:
> Attached is a diff for subtransactions.
Uh, I hate to tell you this, but you wasted your time because the syntax
accepted by CVS tip is not going to be the final syntax. None of what
you wrote here will be useful as soon as Alvaro's pending patch goes in.
regards, tom lane