Re: [GENERAL] Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4

2015-06-19 Thread Adrian Klaver
On 06/19/2015 04:15 AM, Gary Cowell wrote: Hello I'm aware of the automatic transaction abort that occurs in PostgreSQL if you have DML throw an error during a transaction, this prevents future selects within transaction, until rollback or commit (and hence, new transaction). I'm okay with this.

Re: [GENERAL] Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4

2015-06-19 Thread Glyn Astill
> From: Gary Cowell >To: pgsql-general@postgresql.org >Sent: Friday, 19 June 2015, 12:15 >Subject: [GENERAL] Transaction abort difference between psql, isql, ODBC and >JDBC pgsql 8.4 > > > >Hello > >I'm aware of the automatic transaction abort that occurs

[GENERAL] Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4

2015-06-19 Thread Gary Cowell
Hello I'm aware of the automatic transaction abort that occurs in PostgreSQL if you have DML throw an error during a transaction, this prevents future selects within transaction, until rollback or commit (and hence, new transaction). I'm okay with this. Doing all this on Red Hat 6.5 with Postgres