-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> I found with Postgres V 7 I had to limit the length of the SQL to avoid the > error: 'expression too complex'. So I picked 2000 place holders at a time. > MySQL handled up to 10,600 in one expression, so it was the difference in max > sql length: Postgres => 32K chars, MySQL => 64K chars. But really all to long > to > be good style. If you really want to cause yourself such pain in Postgres, you can now change the "stack_depth_limit" inside of postgresdql.conf and then HUP the server. The default is 2048 (kilobytes), but you can set it as high as your OS can handle. As others have said though, there are far more elegant solutions. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605040938 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFEWgRzvJuQZxSWSsgRAmf6AJ9kyMFazDOye4+YT5lT5ZGRTxEsHQCeIHFU nLfGOqD5cY52thuhyop4f2I= =6paY -----END PGP SIGNATURE-----
