PSQL: argument exceeds the maximum length of 1024 bytes
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div>
<div> </div>
<div>What does it mean if the Error: 'argument exceeds the maximum length of 1024 bytes' is raising using psql.</div>
<div>How can I increase this limit?</div>
<div> </div>
<div>Janek Sendrowski</div></div></body></html>
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
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
what is in function jaro?
Dne 12. 10. 2013 19:22 "Janek Sendrowski" <janek12@web.de> napsal(a):
Show quoted text
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.
I looked to source code, and these limits are defined in
/contrib/fuzzystrmatch/ levenshtein.c or fuzzystrmatch.c - you can find
these messages and related constant. Then you can change it and recompile
extension. If I understand to source code well, these functions are heavy
memory extensive - so there is relative low limit as protection to swap or
OOM killer.
One trick:
if you use a verbose mode, then you can get much more info about error.
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
Regards
Pavel
2013/10/12 hubert depesz lubaczewski <depesz@depesz.com>
Show quoted text
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.--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general