From: | Dmitry Samersoff <dms(at)wplus(dot)net> |
---|---|
To: | Jose Soares <jose(at)sferacarta(dot)com> |
Cc: | general <pgsql-general(at)postgreSQL(dot)org>, hackers <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: [HACKERS] TRANSACTIONS |
Date: | 2000-02-22 12:13:12 |
Message-ID: | XFMail.20000222151312.dms@wplus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)wplus(dot)net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-02-22 13:05:26 | Re: [GENERAL] auto number |
Previous Message | Jose Soares | 2000-02-22 11:47:44 | TRANSACTIONS |
From | Date | Subject | |
---|---|---|---|
Next Message | sszabo | 2000-02-22 12:15:20 | Re: [HACKERS] Beta for 4:30AST ... ? |
Previous Message | Peter Eisentraut | 2000-02-22 12:07:29 | Re: [HACKERS] Beta for 4:30AST ... ? |