NT and aborted transaction
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all,
still experimenting NT:
kalman=# begin;
BEGIN
kalman=# select * from a;
ERROR: relation "a" does not exist
kalman=# begin;
BEGIN
kalman=# select * from test;
ERROR: current transaction is aborted, commands ignored until end of transaction block
I think the second begin shall fail instead of open an already invalid transaction.
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFA+bEz7UpzwH2SGd4RAujVAJ4wBx64eSKwokcBUl/l3sJJV9LelwCcDf/Z
K/kv375ERUxwvY8tGUmhmYA=
=K8OT
-----END PGP SIGNATURE-----
On Sun, Jul 18, 2004 at 01:07:32AM +0200, Gaetano Mendola wrote:
kalman=# begin;
BEGIN
kalman=# select * from a;
ERROR: relation "a" does not exist
kalman=# begin;
BEGIN
kalman=# select * from test;
ERROR: current transaction is aborted, commands ignored until end of
transaction blockI think the second begin shall fail instead of open an already invalid
transaction.
We are not gonna use "begin" for starting a subtransaction, so this is a
nonissue. Please apply the savepoints patch and try again.
If you have current CVS tip you'll have for me to post a new patch, in
the next hour or so, because the code has drifted.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Ellos andaban todos desnudos como su madre los pari�, y tambi�n las mujeres,
aunque no vi m�s que una, harto moza, y todos los que yo vi eran todos
mancebos, que ninguno vi de edad de m�s de XXX a�os" (Crist�bal Col�n)