SAGA-GIS Tool Library Documentation (v6.1.0)

Tool Commit/Rollback Transaction

Execute a commit or rollback on open transactions with PostgreSQL source.

Parameters

 NameTypeIdentifierDescriptionConstraints
OptionsHostTextPG_HOSTPassword-
PortIntegerPG_PORT-Minimum: 0
Default: 5432
DatabaseTextPG_NAMEDatabase Name-
UserTextPG_USERUser Name-
PasswordTextPG_PWDPassword-
Available ConnectionsChoiceCONNECTION-Available Choices:
[0]
Default: 0
TransactionsChoiceTRANSACT-Available Choices:
[0] rollback
[1] commit
Default: 1
Save PointTextSAVEPOINT--

Command-line

Usage: saga_cmd db_pgsql 5 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-TRANSACT <str>] [-SAVEPOINT <str>]
  -PG_HOST:<str>  	Host
	Text
  -PG_PORT:<num>  	Port
	Integer
	Minimum: 0
	Default: 5432
  -PG_NAME:<str>  	Database
	Text
  -PG_USER:<str>  	User
	Text
  -PG_PWD:<str>   	Password
	Text
  -TRANSACT:<str> 	Transactions
	Choice
	Available Choices:
	[0] rollback
	[1] commit
	Default: 1
  -SAVEPOINT:<str>	Save Point
	Text