Postgresql SQL Length

[amreiff]

I am working on populating a Postgresql database with news items. I received the following error:

PostgresSQL query failed: PQsendQuery() -- query is too long. Maximum length is 16382

Is the maximum length something I can change or is it set for good? Any thoughts/ideas/HELP!!?? Thanx!

Aaron

[opido]

It's probably in the PGSQL config file. I had the same problem with MySQL a while ago. I don't use PG so I couldn't tell you where the config file is.

try searching for max_allowed_packet or something similar.

[toma42]

The config file is in the data directory, I believe.

[amreiff]

Do you mean the dir where the db is stored?

[toma42]

Yes. The same directory where you control ip security.