[pg-devel] max message length unnecessary?

Johan Ur Riise johan at riise-data.no
Tue Sep 19 00:43:45 UTC 2006


The limit seems to be unnecessary:

jur at lark:/usr/local/lib/common-lisp/systems/pg-cvs$ diff -u v3-protocol.lisp.orig v3-protocol.lisp
--- v3-protocol.lisp.orig       2006-09-19 03:02:13.000000000 +0200
+++ v3-protocol.lisp    2006-09-19 03:04:14.000000000 +0200
@@ -644,9 +644,6 @@
 on the database to which we are connected via CONNECTION. Return
 a result structure which can be decoded using `pg-result'."
   (let ((sql (apply #'concatenate 'simple-string args)))
-    (when (> (length sql) +MAX_MESSAGE_LEN+)
-      (error "SQL statement too long: ~A" sql))
-
     (send-packet connection #\Q `((:cstring ,sql)))
     (%flush connection)
     (do-followup-query connection)))
jur at lark:/usr/local/lib/common-lisp/systems/pg-cvs$

The limit was in effect only under a transaction.

I just tried with 8MB and it works. 


-- 
Hilsen
Johan Ur Riise



More information about the pg-devel mailing list