PQsendQuery: Query is too long

From: Henrik Steffen <steffen(at)city-map(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: PQsendQuery: Query is too long
Date: 2002-01-16 15:38:54
Message-ID: 3C459E8E.7DD1E00A@city-map.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello all,

when doing larger queries, e.g. an insert of lots of text,
I always get "Query too long" if the query is longer then 8192 bytes.

a) What exactly is the reason for this limitation? (postgres, libpq or Pg.pm?)

b) What can I do to avoid this limitation?

Thanks for your help

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (€ 1.86/Min,topcon)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-01-16 15:57:42 Re: oid problem with dumping database (failed sanity check, opr with oid 280515 was not found)
Previous Message Holger Krug 2002-01-16 15:35:38 Re: Different views with same name for different users