-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of gato pardo Sent: Friday, December 30, 2011 8:39 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: pgoledb transaction error Hi: I am moving my data from windows-mssql to Linux-postgresql, but I'am still accessing the data from windows using pgoledb - in order to have compatibility with he old system. Everything is working ok, except when transactions are involved. Examining in this list I found the same kind of error I am having at this moment: "Error message: Unspecified error Engine Used: PgOleDb Error type : commit failed" I did not find what solution was found. Can anyone help me with, at least, some tips ? ------------------------------------------------ Tip 1: Provide the SQL statements you are trying to execute when you get the error; given that is it a "commit"-type error the entire transaction is useful. Tip 2: Make use of the PostgreSQL server logs to see exactly what the server is (has been) attempting to execute instead of the single error message the client is seeing. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
