Обсуждение: PSQL: argument exceeds the maximum length of 1024 bytes
<div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div><div> </div><div>What does it mean if the Error: 'argumentexceeds the maximum length of 1024 bytes' is raising using psql.</div><div>How can I increase this limit?</div><div> </div><div>JanekSendrowski</div></div>
On sob, paź 12, 2013 at 06:30:51 +0200, janek12@web.de wrote:
> What does it mean if the Error: 'argument exceeds the maximum length of 1024 bytes' is raising using psql.
> How can I increase this limit?
How did you achieve it? Can you show screenshot of what you did, and how
the error was presented?
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
I would say it's just a query with to many rows or something like that.
My query was: SELECT jaro('word', col) FROM table.
The tables has ca. 75000 rows. If I'm gonna use the WHERE condition and only select the first 10000 rows, it's working.
So it could be something with the memory, but 1024 bytes?!
Janek Sendrowski
what is in function jaro?
Dne 12. 10. 2013 19:22 "Janek Sendrowski" <janek12@web.de> napsal(a):
I would say it's just a query with to many rows or something like that.
My query was: SELECT jaro('word', col) FROM table.
The tables has ca. 75000 rows. If I'm gonna use the WHERE condition and only select the first 10000 rows, it's working.
So it could be something with the memory, but 1024 bytes?!
Janek Sendrowski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello
I looked to source code and this error message is only in fuzzystrmatch extension. Please, next time, specify a PostgreSQL version number, and used extensions. postgres=# select 10/0;
ERROR: division by zero
Time: 0.793 ms
postgres=# \set VERBOSITY verbose
postgres=# select 10/0;
ERROR: 22012: division by zero
LOCATION: int4div, int.c:719
Time: 0.511 ms
2013/10/12 hubert depesz lubaczewski <depesz@depesz.com>
On sob, paź 12, 2013 at 06:30:51 +0200, janek12@web.de wrote:
> What does it mean if the Error: 'argument exceeds the maximum length of 1024 bytes' is raising using psql.
> How can I increase this limit?
How did you achieve it? Can you show screenshot of what you did, and how
the error was presented?
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general