On 8/25/19 12:40 PM, Rob Sargent wrote
On Aug 25, 2019, at 1:09 PM, David Wall wrote:
Using the latest PostgreSQL, does it matter if my code does a ROLLBACK or a
COMMIT on an non-modifying SELECT statement? My impression is they'd be the
same as nothing is changed and therefore there's
Using the latest PostgreSQL, does it matter if my code does a ROLLBACK
or a COMMIT on an non-modifying SELECT statement? My impression is
they'd be the same as nothing is changed and therefore there's nothing
to commit or rollback, but wondered if there was any difference in how
they are
In JDBC (latest version), I'm using the
org.postgresql.jdbc.PgConnection.getTransactionState() that returns an
enumeration of IDLE, OPEN or FAILED.
I am familiar with IDLE, meaning the connection has a new transaction
started, but isn't doing anything. We think of this as the "normal"
state
On 9/14/18 7:52 AM, James Keener wrote:
I fail to see how that makes everyone here part of a community anymore
than I'm part of the "community" of regulars at a bar I walk into for
the first time.
As I said, the rules can and should apply within the list, but
applying them outside the list
