. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 298 7.6.16. IN AUTONOMOUS TRANSACTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373 9.6. CURRENT_TRANSACTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 383 10. Transaction Control. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 385 10.1. Transaction Statements

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 397 7.7.21. IN AUTONOMOUS TRANSACTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 8.12.3. RDB$GET_TRANSACTION_CN() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539 11.6. CURRENT_TRANSACTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Limbo Transaction Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 18.4.1. Limbo Transaction Options — All The Same? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . options for the gfix database utility. • Shadow file handling. • Cache and buffer handling. • Transaction management. • Cache management. • Starting and stopping a database. • And much, much more …

Особенности использования параметризованных операторов ................ 364 WITH {AUTONOMOUS | COMMON} TRANSACTION .......................................... 366 WITH CALLER PRIVILEGES ........................ подключений (Connection pooling) ............................... 367 Особенности пула транзакций (Transaction pooling) ................................. 367 Особенности обработки исключений ............. .......................................................................... 379 IN AUTONOMOUS TRANSACTION ............................................................................. 379 POST_EVENT

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 6. Transaction Inventory Page — Type 0x03 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . from Firebird 3.0 onwards. The remaining pages consist of Index Root Pages (page type 0x06), Transaction Inventory Pages or TIP (page type 0x03), Pointer Pages (page type 0x04), Index BTree Pages (page database, but the first PIP is always page 1. 0x03 Transaction Inventory Page (TIP). A page that keeps track of the stat of transactions. Each transaction is represented by a pair of bits in a bitmap. Valid

ROLLBACK TO SAVEPOINT SAVEPOINT Внутренние точки сохранения Точки сохранения и PSQL SET TRANSACTION IGNORE LIMBO LOCK TIMEOUT NO AUTO UNDO 9. Операторы PSQL Блок BEGIN ... END может быть {AUTONOMOUS|COMMON} TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL [DATA SOURCE] AS USER, PASSWORD и ROLE Параметризованные операторы Предостережения для оператора EXECUTE STATEMENT IN AUTONOMOUS TRANSACTION EXIT FOR EXECUTE STATEMENT ... DO FOR SELECT ... INTO ... DO Предложение AS CURSOR IN AUTONOMOUS TRANSACTION LEAVE OPEN CURSOR Разрешение использования оператора PLAN в триггерах Подзапросы в выражениях

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 15. Transaction Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 18.22. SET TRANSACTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . command on its own.  In the output from HELP SET, there doesn’t appear to be any help on the SET TRANSACTION command. Chapter 7. Getting Help 13 Chapter 8. Connecting To A Database A sample database named

4.1. Start transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.2. Commit transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.3. Rollback transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.7. Transaction information request . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 385 7.7.20. IN AUTONOMOUS TRANSACTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 495 11.6. CURRENT_TRANSACTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 509 12.1.1. SET TRANSACTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

335544590 dsql_dup_option Option specified more than once -104 335544591 dsql_tran_err Unknown transaction option -104 335544592 dsql_invalid_array Invalid array reference -104 335544608 command_end_err el You created an indirect dependency on uncommitted metadata. You must roll back the current transaction. -104 335544821 dsql_column_pos_err Invalid column position used in the @1 clause -104 335544822 dsql_crdb_prepare_err Cannot prepare a CREATE DATABASE/SCHEMA statement -532 335544469 trans_invalid Transaction marked invalid by I/O error Firebird 2.1 Error Codes -551 335544352 no_priv No permission for