PostgreSQL - Connection
PostgreSQL - Connection
Creates a connection to a PostgreSQL database from a connection configured in the workspace. The ID of this action is used as a reference by every other PostgreSQL action in the flow — such as PostgreSQL: Query, PostgreSQL: Begin transaction and PostgreSQL: Close connection.
- Version 2.0
- Version 1.0
Time limits
Optional fields that limit, in seconds, how long opening the connection and running its queries may take. When at least one of these fields is filled in, a query that reaches the limit is canceled on the database server and the action fails; the connection stays open and can still be used — for example, to roll back a transaction. When none of them is filled in, the connection keeps the previous behavior: a query that reaches the limit (120 seconds, or the one set on the query itself) makes the action fail, but it is not canceled and keeps running on the server.
Connection timeout
Maximum time, in seconds, the action waits for the PostgreSQL server to accept the connection. The minimum value is 1. When empty, there is no limit. Optional field.
Default query timeout
Maximum time, in seconds, of every query run on this connection, except queries that set their own limit in the Query timeout field of the PostgreSQL: Query action. A value of 0 means no limit. When empty, the limit is 120 seconds. Optional field.
Returns
This action has no direct returns. Its ID is used as a reference by the other PostgreSQL actions.
Rules and Conditions
- In Version 2.0, the Connection field is required and the connection must be configured beforehand in the workspace's Connections tab.
- In Version 1.0, the Connection string field is required.
- The fields of the Time limits group are optional and their values are in seconds.
- The Connection timeout field accepts values from
1. - In the Default query timeout field,
0means no limit.