pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtransaction aborted
3+ messages / 3 participants
[nested] [flat]
* transaction aborted
@ 2000-01-27 20:32 Mark Wilson <mwilson@sundog.larc.nasa.gov>
0 siblings, 2 replies; 3+ messages in thread
From: Mark Wilson @ 2000-01-27 20:32 UTC (permalink / raw)
To: pgsql-sql
Hello,
Can anyone give me a more detailed explanation of what's going on? I'm
getting the following error during a series of database inserts:]
NOTICE: (transaction aborted): queries ignored until END
Thanks!
--- fax: (757)825-8659
Mark Wilson voice: (757)827-4631
Analytical Services & Materials, Inc. email: m.r.wilson@larc.nasa.gov
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] transaction aborted
@ 2000-01-29 07:53 root <root@feki.toppoint.de>
parent: Mark Wilson <mwilson@sundog.larc.nasa.gov>
1 sibling, 0 replies; 3+ messages in thread
From: root @ 2000-01-29 07:53 UTC (permalink / raw)
To: m.r.wilson@larc.nasa.gov; +Cc: pgsql-sql
> Hello,
>
> Can anyone give me a more detailed explanation of what's going on? I'm
> getting the following error during a series of database inserts:]
>
> NOTICE: (transaction aborted): queries ignored until END
>
I would expect, that one insert produces an error and therefore the whole
transaction has been aborted. Did you send several commands with
ONE command ?
Marten
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] transaction aborted
@ 2000-01-29 11:14 Peter Eisentraut <peter_e@gmx.net>
parent: Mark Wilson <mwilson@sundog.larc.nasa.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2000-01-29 11:14 UTC (permalink / raw)
To: m.r.wilson@larc.nasa.gov; +Cc: pgsql-sql
On 2000-01-27, Mark Wilson mentioned:
> Hello,
>
> Can anyone give me a more detailed explanation of what's going on? I'm
> getting the following error during a series of database inserts:]
>
> NOTICE: (transaction aborted): queries ignored until END
One of your inserts failed (check the error messages) and therefore the
transaction in progress was aborted. In order to continue, you must
explicitly roll it back (ROLLBACK command).
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-01-29 11:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-27 20:32 transaction aborted Mark Wilson <mwilson@sundog.larc.nasa.gov>
2000-01-29 07:53 ` root <root@feki.toppoint.de>
2000-01-29 11:14 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox