pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Where do I execute the DISCONNECT command? 2+ messages / 2 participants [nested] [flat]
* Where do I execute the DISCONNECT command? @ 2006-06-27 23:22 adey <adey11@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: adey @ 2006-06-27 23:22 UTC (permalink / raw) To: pgsql-admin; postgresql-l <postgresql-l@Groups.ittoolbox.com> 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Where do I execute the DISCONNECT command? @ 2006-06-28 00:04 Michael Fuhr <mike@fuhr.org> parent: adey <adey11@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Michael Fuhr @ 2006-06-28 00:04 UTC (permalink / raw) To: adey <adey11@gmail.com>; +Cc: pgsql-admin On Wed, Jun 28, 2006 at 11:22:18AM +1200, adey wrote: > Please could you tell me where I must execute the following to disconnect > idle transactions in Potgres:- > > EXEC SQL DISCONNECT [connection-name]; This is ECPG syntax; you'd use it in client programs that embed SQL commands alongside C code. http://www.postgresql.org/docs/8.1/interactive/ecpg.html http://www.postgresql.org/docs/8.1/interactive/ecpg-disconnect.html > 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. See "Connecting to the Database Server" in the ECPG documentation. http://www.postgresql.org/docs/8.1/interactive/ecpg-connect.html I'm guessing you're looking for something else. Could you explain a bit more about what you're trying to do? -- Michael Fuhr ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-06-28 00:04 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-06-27 23:22 Where do I execute the DISCONNECT command? adey <adey11@gmail.com> 2006-06-28 00:04 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox