Horton

Re: pg_dump / copy bugs with "big lines" ?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Daniel Verite" <daniel@manitou-mail.org>
Cc: "Alvaro Herrera" <alvherre@2ndquadrant.com>, "Robert Haas" <robertmhaas@gmail.com>, "Jim Nasby" <Jim.Nasby@bluetreble.com>, "Ronan Dunklau" <ronan.dunklau@dalibo.com>, "pgsql-hackers" <pgsql-hackers@postgresql.org>
Date: 2016-03-01T21:48:43Z
Lists: pgsql-hackers 
"Daniel Verite" <daniel@manitou-mail.org> writes:
> I've tried adding another large field to see what happens if the whole row
> exceeds 2GB, and data goes to the client rather than to a file.
> My idea was to check if the client side was OK with that much data on
> a single COPY row, but it turns out that the server is not OK anyway.

BTW, is anyone checking the other side of this, ie "COPY IN" with equally
wide rows?  There doesn't seem to be a lot of value in supporting dump
if you can't reload ...

			regards, tom lane

Commits

  1. Fix overflow check in StringInfo; add missing casts

  2. Permit dump/reload of not-too-large >1GB tuples