RE: [HACKERS] TRANSACTIONS

On 22-Feb-2000 Jose Soares wrote:
> begin transaction;
> create table tmp(a int);
> insert into tmp values (1);
> insert into tmp values (1000000000000000000000000000000000);
> ERROR:  pg_atoi: error reading "1000000000000000000000000000000000":
> Numerical result out of range
> commit;
> select * from tmp;
> ERROR:  tmp: Table does not exist.
> -------------------------------------------------------
> Interbase, Oracle,Informix,Solid,Ms-Access,DB2:
                                   ^^^^^^^^^
 AFAIK, MS Access have no transactions inside it,
 Informix (at least old versions I worked with) always
 perform create,drop, alter object outside transaction
 but IMHO it's not right behavior.

 I believe postgres's behavior more meaningful,
but IMHO, this example is quite far from real life.



--
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...