diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/connection.rst | 4 | ||||
| -rw-r--r-- | doc/src/usage.rst | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/connection.rst b/doc/src/connection.rst index 07e494a..92178f3 100644 --- a/doc/src/connection.rst +++ b/doc/src/connection.rst @@ -419,8 +419,8 @@ The ``connection`` class By default, any query execution, including a simple :sql:`SELECT` will start a transaction: for long-running programs, if no further - action is taken, the session will remain "idle in transaction", a - condition non desiderable for several reasons (locks are held by + action is taken, the session will remain "idle in transaction", an + undesirable condition for several reasons (locks are held by the session, tables bloat...). For long lived scripts, either ensure to terminate a transaction as soon as possible or use an autocommit connection. diff --git a/doc/src/usage.rst b/doc/src/usage.rst index e83b128..9dd31df 100644 --- a/doc/src/usage.rst +++ b/doc/src/usage.rst @@ -679,7 +679,7 @@ older versions). By default even a simple :sql:`SELECT` will start a transaction: in long-running programs, if no further action is taken, the session will - remain "idle in transaction", a condition non desiderable for several + remain "idle in transaction", an undesirable condition for several reasons (locks are held by the session, tables bloat...). For long lived scripts, either make sure to terminate a transaction as soon as possible or use an autocommit connection. |