Please could you tell me where I must execute the following to disconnect idle transactions in Potgres:-
EXEC SQL DISCONNECT [connection-name];
I've tried variations of this syntax in PGAdmin, psql, and the Linus command line in both v8.1.4 and v7.4.2 - all of which fail.
COuld you also tell me what "connection-name" is? I've assumed it's the PID as listed in pg_stat_activity, but haven't been able to test this as I can't get the syntax and environment correct.