Re: transaction abortion

On Mon, Feb 25, 2002 at 10:35:14PM -0800, Kancha . wrote:
> 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 ??

Look at the error message and use that to fix the problem.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> If the company that invents a cure for AIDS is expected to make their
> money back in 17 years, why can't we ask the same of the company that
> markets big-titted lip-syncing chicks and goddamn cartoon mice?