pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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