| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "Kancha (dot)" <kancha2np(at)yahoo(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: transaction abortion |
| Date: | 2002-02-26 08:17:04 |
| Message-ID: | 20020226191704.B21285@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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(at)svana(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ricardorsj | 2002-02-26 12:01:03 | Query doesn't work anymore on 7.2 |
| Previous Message | Kancha . | 2002-02-26 07:51:39 | Re: [SQL] transaction abortion |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erle Czar Mantos | 2002-02-26 08:20:52 | Re: test the existence of a database |
| Previous Message | Bradley Baetz | 2002-02-26 08:09:55 | Re: [SQL] query optimistaion problems |