Search Postgresql Archives

Re: Queries with more than 1692 characters hang

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 02/26/2014 12:09 PM, Jason McKellar wrote:
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.

Not sure what is going on, but so we are on same page.

Where is the 9.2.2 server located, local or over network?

So assuming psql is the command line client:

You can run the exact same query against another Postgres server that is not version 9.2.2 and not have a problem?

Is it only this specific 9.2.2 instance you have a problem with?

What other versions of Postgres have you had success with?

Are you using the Mac version of readline(libedit) or libreadline?


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





--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux