Re: [HACKERS] TRANSACTIONS - Mailing list pgsql-general

From Jose Soares
Subject Re: [HACKERS] TRANSACTIONS
Date
Msg-id 38B3DEFC.A9B2005D@sferacarta.com
Whole thread Raw
In response to RE: [HACKERS] TRANSACTIONS  (Dmitry Samersoff <dms@wplus.net>)
List pgsql-general

Dmitry Samersoff wrote:

> 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 don't know and I don't care about old software,
I'm talking about Ms_Access97 and Informix 8.

--
Jose' Soares
Bologna, Italy                     Jose@sferacarta.com



pgsql-general by date:

Previous
From: Ingo Assenmacher
Date:
Subject: Re: [GENERAL] RestrictionClauseSelectivity
Next
From: Jose Soares
Date:
Subject: Re: [GENERAL] Re: [HACKERS] TRANSACTIONS