Begin Transaction
- Author: O.Conrad (c) 2013
- Menu: Database | PostgreSQL | Tools
Description
Begins a transaction, which will be finished later with a commit or rollback. Tries to add a save point, if already in transaction mode.
Parameters
Name | Type | Identifier | Description | Constraints | |
---|---|---|---|---|---|
Options | Host | text | PG_HOST | - | Default: 127.0.0.1 |
Port | integer number | PG_PORT | - | Minimum: 0 Default: 5432 | |
Database | text | PG_DB | - | - | |
User | text | PG_USER | - | - | |
Password | text | PG_PWD | - | - | |
Save Point | text | SAVEPOINT | - | Default: SAVEPOINT_01 |
Command Line
Usage: saga_cmd db_pgsql 4 [-PG_HOST] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-SAVEPOINT ] -PG_HOST: Host text Default: 127.0.0.1 -PG_PORT: Port integer number Minimum: 0 Default: 5432 -PG_DB: Database text -PG_USER: User text -PG_PWD: Password text -SAVEPOINT: Save Point text Default: SAVEPOINT_01