Skip site navigation (1) Skip section navigation (2)

Re: [SQL] transaction abortion

From: "Kancha (dot)" <kancha2np(at)yahoo(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-sql(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] transaction abortion
Date: 2002-02-26 07:51:39
Message-ID: 20020226075139.15689.qmail@web14914.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
Sorry, 

Please ignore my mails on this subject. Yes it was a
mistake in the select query. 

Thanks for pointing out chrisopher.


--- Christopher Kings-Lynne
<chriskl(at)familyhealth(dot)com(dot)au> wrote:
> Hi Kancha,
> 
> Chances are you have a syntax error in the select
> statement.  Can you please
> port the entire set of queries you are trying to run
> and we'll look at them.
> 
> Chris
> 
> > -----Original Message-----
> > From: pgsql-sql-owner(at)postgresql(dot)org
> > [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf
> Of Kancha .
> > Sent: Tuesday, 26 February 2002 2:35 PM
> > To: pgsql-sql(at)postgresql(dot)org
> > Cc: pgsql-general(at)postgresql(dot)org
> > Subject: [SQL] transaction abortion
> >
> >
> > I'm in a situtation where transaction is aborted.
> I'm
> > a newbie so please help.
> >
> > I start transaction with begin then do some
> queries
> > like update and insert. So far so good, but when i
> run
> > select query within the transaction the whole
> > transaction is aborted.
> >
> > what should i do ??
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Sports - Coverage of the 2002 Olympic Games
> > http://sports.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

In response to

pgsql-sql by date

Next:From: Erle Czar MantosDate: 2002-02-26 07:53:02
Subject: Re: On delete cascade!
Previous:From: David BOURIAUDDate: 2002-02-26 07:51:30
Subject: Re: About referential integrity.

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2002-02-26 08:17:04
Subject: Re: transaction abortion
Previous:From: Kancha .Date: 2002-02-26 07:43:41
Subject: Re: [SQL] transaction abortion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group