Re: PSQL: argument exceeds the maximum length of 1024 bytes

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PSQL: argument exceeds the maximum length of 1024 bytes
Date: 2013-10-12 17:21:42
Message-ID: trinity-c54f1bc9-b84b-4d67-ba36-7b33cc8c2a10-1381598502837@3capp-webde-bs04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-10-12 17:25:16 Re: PSQL: argument exceeds the maximum length of 1024 bytes
Previous Message hubert depesz lubaczewski 2013-10-12 17:03:46 Re: PSQL: argument exceeds the maximum length of 1024 bytes