Hello,
It appears in MySql 3.23 the limit is 16 MB. In 4.0 and later, it is 1 GB
http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html
Could someone tell me where I can find PostgreSQL doc about the query
length please
Tks a lot!
Hello,
Just curious to know whether postgresql has any length constraint
about where part, such as
Query =
[
select col1, col2, ... coln
from table 1, table2,
where
constraint1 + constraint2 +................................constraintN
]
Is there any length arrange for the Query str such as 500M, 1G, etc?
Or the query can be as long as it is.
Thanks a lot!
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
