Unix Technical Forum

BUG #2332: commands ignored until end of transaction block

This is a discussion on BUG #2332: commands ignored until end of transaction block within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 2332 Logged by: Vinod Bapure Email address: bapure123@rediffmail.com PostgreSQL version: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 10:50 AM
Vinod Bapure
 
Posts: n/a
Default BUG #2332: commands ignored until end of transaction block


The following bug has been logged online:

Bug reference: 2332
Logged by: Vinod Bapure
Email address: bapure123@rediffmail.com
PostgreSQL version: 8.1.2
Operating system: Red Hat Linux 8.0
Description: commands ignored until end of transaction block
Details:

Hi,

I am using psqlODBC driver to connect postgres 8.1.2 database. As I run my
application to query few rows from the database I am getting following error
at database end

ERROR: current transaction is aborted, commands ignored until end of
transaction block

Please let me know if it is due to driver or wrong query from my
application.

My application is running on host which has following configuration

Dual Xeon Processor 2.4 Ghz
2.0 GB RAM
40 GB HDD
Operating System: RHEL 4.0 ES
ODBC Driver: psqlODBC


Postgres (8.1.2) is runnging on host with following configuration

Pentium4@3.0ghz
512mb Ram
40gb

Operating System: Red Hat Linux 8.0

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 10:50 AM
William ZHANG
 
Posts: n/a
Default Re: BUG #2332: commands ignored until end of transaction block

There must be some error caused by the SQL statements sent by the
application or driver.
You can log the SQL statements by setting log_statement to true in
postgres.conf.

Regards,
William ZHANG


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:58 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com