Queries with more than 1692 characters hang

From: Jason McKellar <jason(at)deadtreepages(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Queries with more than 1692 characters hang
Date: 2014-02-26 20:09:32
Message-ID: CAGZuaCwaqkbfzMpo8emCv+w9596BVgvtWgn+DqGpW6To3MEJQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having a very strange problem where any queries I make that have more
than 1692 characters in them hang forever (cancel backend doesn't work
either). It only happens on my computer which is OSX 10.9 and I've tried
psql 9.2.1 and 9.3.3. The server is 9.2.2 and it only happens when querying
this specific server.

The query I'm making is "select 'llllll';" where "l" is repeated to make
the query 1692 characters long including the spaces and keywords before the
semi-colon.

Any idea what happened?

Thanks,

Jason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-02-26 21:11:14 Re: Queries with more than 1692 characters hang
Previous Message David Johnston 2014-02-26 18:35:49 Re: xpath functionerror