Re: [GENERAL] PSQL: argument exceeds the maximum length of 1024 bytes

2013-10-12 Thread Pavel Stehule
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 t

Re: [GENERAL] PSQL: argument exceeds the maximum length of 1024 bytes

2013-10-12 Thread Pavel Stehule
what is in function jaro? Dne 12. 10. 2013 19:22 "Janek Sendrowski" 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

Re: [GENERAL] PSQL: argument exceeds the maximum length of 1024 bytes

2013-10-12 Thread Janek Sendrowski
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 1 rows, it's working. So it could be something with the memory, but 1024 byte

Re: [GENERAL] PSQL: argument exceeds the maximum length of 1024 bytes

2013-10-12 Thread hubert depesz lubaczewski
On sob, paź 12, 2013 at 06:30:51 +0200, jane...@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 wa

[GENERAL] PSQL: argument exceeds the maximum length of 1024 bytes

2013-10-12 Thread janek12
Hi,   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?   Janek Sendrowski