Re: [GENERAL] setting connection/ query timeout

2011-05-02 Thread tamanna madaan
Thanks Daniele -Original Message- From: Daniele Varrazzo [mailto:daniele.varra...@gmail.com] Sent: Wed 4/20/2011 1:15 AM To: tamanna madaan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] setting connection/ query timeout On Tue, Apr 19, 2011 at 8:09 PM, tamanna madaan wrote

Re: [GENERAL] setting connection/ query timeout

2011-04-19 Thread Daniele Varrazzo
On Tue, Apr 19, 2011 at 8:09 PM, tamanna madaan wrote: > Sometimes this query gets stuck for unknown reason . So, for this particular > query I want to set a timeout > . I dont want to change "statement_timeout" in postgresql.conf as this would > affect all the connections/queries. > I just want

[GENERAL] setting connection/ query timeout

2011-04-19 Thread tamanna madaan
Hi All I am using postgres-8.1.2 . In postgresql.conf I have set : #statement_timeout = 0 I am executing the below query just to check if postgres is allowing connections or not . psql -Uslon -d -h -c "select 1;" Sometimes this query gets stuck for unknown reason . So, for this particu