MOON
Server: Apache
System: Linux kvm.asjudinet.com 5.14.0-611.54.6.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Fri May 15 04:23:18 EDT 2026 x86_64
User: asjudine (1001)
PHP: 8.0.30
Disabled: exec,passthru,shell_exec,system
Upload Files
File: //proc/self/root/usr/share/doc/firebird/sql.extensions/README.management_statements_psql.md
# Management Statements in PSQL

Before Firebird 4, management statements were not allowed inside PSQL blocks. They were allowed only as top-level SQL statements, or as top-level statement of an `EXECUTE STATEMENT` embedded in a PSQL block.

Now they are allowed inside PSQL blocks (triggers, procedures, execute block) directly.

As many applications depends that some management statements be issued on the connection start, `ON CONNECT` triggers is a good place to put them in this situation.

The management statements part of this improvement are:
- `ALTER SESSION RESET`
- `SET BIND OF ... TO`
- `SET DECFLOAT ROUND`
- `SET DECFLOAT TRAPS TO`
- `SET ROLE`
- `SET SESSION IDLE TIMEOUT`
- `SET STATEMENT TIMEOUT`
- `SET TIME ZONE`
- `SET TRUSTED ROLE`

## Examples

```sql
create or alter trigger on_connect on connect
as
begin
    set bind of decfloat to double precision;
    set time zone 'America/Sao_Paulo';
end
```