Apache 2.2, PHP 5.3.4, Zend Db 1.11.11, PostgreSQL 9.0.4

I am porting an application from MySQL to PGSQL using PHP with Zend Db / PDO for database abstraction.

My application enters a geometry column using the ST_GeomFromText() function.

With a small number of vertices this works fine but when a polygon has too many vertices PHP crashes.

I have captured the insert statement and run it via pgAdmin III and that works fine. Since the problem only occurs once the polygon has sufficient vertices, I assume that there is some limit being applied either to the length of the expression or to the size of the data / insert query but this limit is only being applied via the client connection from PHP since running the same insert on pgAdmin works.

Does anyone know what limit I'm hitting and if there are any runtime configuration settings I can set in my PHP to increase it?

Thanks. Dan

If it works fine in pgAdmin and the query "crashes" PHP (whatever that means) this seems to be a PHP issue rather than a Postgres issue to me.

You should take this question to a PHP forum.

When I say crashes PHP I mean I get a connection reset error and apache restarts so PHP can't report what went wrong.

The reason I post it here rather than on a PHP forum is that it seems like it might be caused by a configuration option on the PG client connection since smaller queries work fine.

What shammat says is likely sound: if it's working in a different client, the problem is not with PostgreSQL. However:

* Post your actual query here, maybe someone can find something wrong with it.

* Try your query using PHP's PostgreSQL extension. If that works, then it's likely a PDO issue.

Thanks Shammat and Futurity.

I have tried that and it does work so it does appear to be an issue with Zend_Db / PDO but I was hoping it may be a default configuration setting I could override rather than an error in the pdo_pgsql extension.

Cheers. Dan