Received: from mail.greatbasin.net (mail.greatbasin.net [207.228.35.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5SKNwa28114; Thu, 28 Jun 2001 16:23:58 -0400 (EDT) (envelope-from jeremy@wellsgaming.com) Received: from localhost (rno-dsl0b-131.gbis.net [216.82.145.131]) by mail.greatbasin.net (8.9.3-MySQL-0.2.3b/8.9.3) with ESMTP id NAA22036; Thu, 28 Jun 2001 13:23:45 -0700 (PDT) Message-Id: <200106282023.NAA22036@mail.greatbasin.net> Date: Thu, 28 Jun 2001 13:24:12 -0700 From: Jeremy Buchmann Content-Type: text/plain; format=flowed; charset=us-ascii Subject: Re: timeout Cc: pgsql-admin@postgresql.org, pgsql sql To: Jie Liang X-Mailer: Apple Mail (2.388) In-Reply-To: Mime-Version: 1.0 (Apple Message framework v388) Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/172 X-Sequence-Number: 1743 > Is ther any to set a timeout when execute a sql stmt?? I believe this depends on the interface...for example, in JDBC, it is this: Statement s = new Statement(); s.setQueryTimeout(20); // Sets query timeout to 20 seconds. ... I don't know what other interfaces offer timeouts, but that's where you should look to find out. --Jeremy