dbTalk Databases Forums  

[BUGS] BUG #2332: commands ignored until end of transaction block

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2332: commands ignored until end of transaction block in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vinod Bapure
 
Posts: n/a

Default [BUGS] BUG #2332: commands ignored until end of transaction block - 03-17-2006 , 07:31 AM







The following bug has been logged online:

Bug reference: 2332
Logged by: Vinod Bapure
Email address: bapure123 (AT) rediffmail (DOT) 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

Reply With Quote
  #2  
Old   
William ZHANG
 
Posts: n/a

Default Re: [BUGS] BUG #2332: commands ignored until end of transaction block - 03-18-2006 , 05:55 PM






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



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.