Re: Subbestions: 1) Query timeout 2) Session kill by same login

DGPickett wrote:
>  - Query times could be limited, by login id or class, so they error
> out after N seconds.  There could even be two thresholds, one long one
> for the entire query and another, shorter one for time without a row
> delivered or churned.  This way, the user would not have to bother
> admin, and if they did not know they had a runaway, it would take care
> of itself.  If the user could institute a second, shorter limit, that
> would add to the value of the feature, as the limit could be tailored
> by query.  Churn in process  when timed out would be rolled back for
> that query only if a transaction is in process.  The session and any
> transactions would remain active.

See statement_timeout.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com