Verdict: really dumb. Directly after posting, I dove into the 7.1.3 code,
curious about the details. Not finding any such error ("query .. too long"),
it was obviously a link problem. Sure enough, old, system RedHat libs.
Lots of testing with the right libs & huge input does fine.
Sorry folks. Please ignore.
-jeremy
On Thu, Nov 01, 2001 at 02:33:11AM -0800, Jeremy Wohl wrote:
> Hi folks,
>
> How does one insert large 'text' fields via libpq? That is, data in
> insert/update statements that exceed the 16K limit in stock 7.1.3 setups.
>
> For the moment, I'm iterating over a concat (column = column || 'next chunk'),
> but that's ~64 net trips for my average 1meg entries.
>
> I suspect there's a coming, unimplemented API for these types opened up by
> TOAST, to obviate Large Objects. However, to ease current requirements,
> I hope I'm doing something really dumb.
>
> Thoughts?
>
> thanks,
> -jeremy
> _____________________________________________________________________
> jeremy wohl ..: http://igmus.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
