Extracted from Pike v7.8 release 866 at 2016-11-06.
pike.ida.liu.se
[Top]
Sql
Sql.pgsql

Method Sql.pgsql()->resync()


Method resync

void resync()

Description

Resyncs the database session; typically used to make sure the session is not still in a dangling transaction.

If called while queries/portals are still in-flight, this function is a no-op.

If called while the connection is in idle state, the function is lightweight and briefly touches base with the database server to make sure client and server are in sync.

If issued while inside a transaction, it will rollback the transaction, close all open cursors, drop all temporary tables and reset all session variables to their default values.

See also

cancelquery() , reload()

Note

This function is PostgreSQL-specific, and thus it is not available through the generic SQL-interface.