[GENERAL] Cannot commit when autoCommit is enabled error

Dear group, We have been using postgresql-jdbc-8.3-604, and recently we started using postgresql-jdbc-9.2, everything seems working fine, except we are getting this error and could not find the solution yet. This related to our reporting and I could say that it is not happening every report we run.

[GENERAL] converting Informix outer to Postgres

Hi all, I have been working on this Informix SQL query which has an outer join. I have attached Informix query and my "supposedly" solution to this query but I cannot get the same count. I appreciate for any help. Thanks. --Informix query select count(u.id) from user u, invention i, inv_contracts

Re: [GENERAL] creating table while slony-I replication is running

e for other SQL commands, like inserting INDEXs,FUNCTIONS, etc.) thanks for reply/help >Hi Gurkan, ? >I just tried the same but didn't face a problem while doing so. > >You can try the same steps that I did: > >1. Made a exec_scr file for Slonik with execute script command &

[GENERAL] creating table while slony-I replication is running

--- add_table.sql ------ CREATE TABLE gurkan ( id serial not null , fname varchar(155), lname varchar(155), primary key (id) ); -- ERROR: - [EMAIL PROTECTED] bin]$ ./add_table.sh :9: PGRES_FATAL_ERROR select "_edb