Is there a way to set the timeout on a PostgreSQL query?

[vfclists]

Is there a way to set the timeout on a PostgreSQL query?

Is there some Params or other means of telling a query or a connection how long to wait before a query reports a time out? If its not possible at the level of the query can it be set on the connection level?

[olehs]

There is a 'connect timeout' parameter:

Code: Select all

ZConnection.Properties.Add('timeout=10');