Tool Begin Transaction

Begins a transaction, which will be finished later with a commit or rollback. Tries to add a save point, if already in transaction mode.

Author: O.Conrad (c) 2013
Menu: Database|PostgreSQL|Tools

Parameters

	Name	Type	Identifier	Description	Constraints
Options	Host	Text, CMD	`PG_HOST`	Password	-
	Port	Integer, CMD	`PG_PORT`	-	Minimum: 0 Default: 5432
	Database	Text, CMD	`PG_NAME`	Database Name	-
	User	Text, CMD	`PG_USER`	User Name	-
	Password	Text, CMD	`PG_PWD`	Password	-
	Available Connections	Choice, GUI	`CONNECTION`	-	Available Choices: Default: 0
	Save Point	Text	`SAVEPOINT`	-	Default: SAVEPOINT_01

Command-line

Usage: saga_cmd db_pgsql 4 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-SAVEPOINT <str>]
  -PG_HOST:<str>  	Host
	Text, CMD
  -PG_PORT:<num>  	Port
	Integer, CMD
	Minimum: 0
	Default: 5432
  -PG_NAME:<str>  	Database
	Text, CMD
  -PG_USER:<str>  	User
	Text, CMD
  -PG_PWD:<str>   	Password
	Text, CMD
  -SAVEPOINT:<str>	Save Point
	Text
	Default: SAVEPOINT_01