Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END

Thanks Mike, I had the same problem and couldn't figure it out. I forgot
that since the last time I ran this type of routine I had added some
quotes in. I forgot to add the routines to handle the single quotes in
the new program.

Tim in Columbia MD

On Sat, 18 Dec 1999, Mike Mascari wrote:

> Alex Guryanow wrote:
> >
> > NOTICE: (transaction aborted): queries ignored until
> >
> > What means this message? And why this happens?
> >
> > Best regards,
> > Alex
>
> That message appears when an error has occurred in a
> transaction. It means that no other SQL statements will be
> processed until the transaction has ended and a new one has
> begun. For example:
>
> It sounds as if some of your INSERT statements are not being
> properly executed, often due to embedded single quotes in
> text strings, lack of NULL values for missing datetime
> values, or some other such syntax error. You should be able
> to use PQresultStatus() and PQerrorMessage() to determine
> precisely the error which is causing the transaction to
> abort.
>
> Hope that helps,
>
> Mike Mascari
>