Re: [GENERAL] Tutorial

2000-02-23 Thread Louis Bertrand
Have you looked at Bruce Momjian's book-in-progress (see the documentation page). It's coming along nicely and covers some material better than the tutorial. Ciao --Louis <[EMAIL PROTECTED]> Louis Bertrand http://www.bertrandtech.on.ca/ Bertrand Technical Services, Bowmanville, ON, Cana

[GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-23 Thread Jose Soares
Don Baccus wrote: > At 11:32 AM 2/22/00 -0500, Tom Lane wrote: > > >I see no way that allowing the transaction to commit after an overflow > >can be called consistent with the spec. > > You are absolutely right. The whole point is that either a) everything > commits or b) nothing commits. > > Ha

Re: [GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-23 Thread Jose Soares
Sorry for my english, Tom, but the point is another, I'm talking about transactions not about error messages. This is only a stupid example how to abort a transaction, PostgreSQL aborts automatically transactions if an error occurs, even an warning or a syntax error. I can believe that all other

[GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-23 Thread Jose Soares
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 (10); > > ERROR: pg_atoi: error reading "10": > > Numerical

Re: [GENERAL] RestrictionClauseSelectivity

2000-02-23 Thread Ingo Assenmacher
Hi. Thanks for your response. omid omoomi schrieb: > > hi,put it in quotes: > delete from aktuelles where index='9'; > better not using some predefined key words like "index" as field names. > >=>delete from aktuelles where index=9; > > > >which results in: > > > >ERROR: RestrictionClauseSele

Re: [GENERAL] RestrictionClauseSelectivity

2000-02-23 Thread omid omoomi
hi,put it in quotes: delete from aktuelles where index='9'; better not using some predefined key words like "index" as field names. >From: Ingo Assenmacher <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [GENERAL] RestrictionClauseSelectivity >Date: Wed, 23 Feb 2000 12:55:43 +0100 > >Hi All!

[GENERAL] RestrictionClauseSelectivity

2000-02-23 Thread Ingo Assenmacher
Hi All! I have the following table: Name: recent +--+--+---+ | Field | Type| Length| +--+--+---+ | datu

Re: [GENERAL] AW: [HACKERS] TRANSACTIONS

2000-02-23 Thread Wim Ceulemans
Zeugswetter Andreas SB wrote: > > > Jose Soares <[EMAIL PROTECTED]> writes: > > > --- > > > Interbase, Oracle,Informix,Solid,Ms-Access,DB2: > > > --- > > > connect hygea.gdb; > > > create tabl

[GENERAL] AW: [HACKERS] TRANSACTIONS

2000-02-23 Thread Zeugswetter Andreas SB
> >I see no way that allowing the transaction to commit after an overflow > >can be called consistent with the spec. > > You are absolutely right. The whole point is that either a) everything > commits or b) nothing commits. > Having some kinds of exceptions allow a partial commit while other >

[GENERAL] AW: [HACKERS] TRANSACTIONS

2000-02-23 Thread Zeugswetter Andreas SB
> Jose Soares <[EMAIL PROTECTED]> writes: > > --- > > Interbase, Oracle,Informix,Solid,Ms-Access,DB2: > > --- > > connect hygea.gdb; > > create table temp(a int); > > insert into temp values (

[GENERAL] Tutorial

2000-02-23 Thread Marco Giardini
Is there a gorodd postgresql tutorial available on the NET? Something better than the tutorial available on the Postgresql web of course. Thanks .oesse. -- -- +-+-+-+-+-+ +-+-+-+-+-+-+-+-+ |m|a|r|c|o| |g|i|a|r|d|i|n|i| +-+-+-+-+-+ +