Postgres Pro
Downloads
Home   >   mailing lists

Re: PSQL: argument exceeds the maximum length of 1024 bytes - Mailing list pgsql-general

From Janek Sendrowski
Subject Re: PSQL: argument exceeds the maximum length of 1024 bytes
Date
Msg-id trinity-c54f1bc9-b84b-4d67-ba36-7b33cc8c2a10-1381598502837@3capp-webde-bs04
Whole thread Raw
In response to Re: PSQL: argument exceeds the maximum length of 1024 bytes  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: PSQL: argument exceeds the maximum length of 1024 bytes
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: PSQL: argument exceeds the maximum length of 1024 bytes
Next
From: Pavel Stehule
Date:
Subject: Re: PSQL: argument exceeds the maximum length of 1024 bytes