The column is a bytea. I'm working out a way to limit the size on the front end.
Chuck On Tue, Nov 6, 2018 at 1:44 PM <[email protected]> wrote: > As someone pointed out, there is a limit with bytea (Blob's). > To test if it is bytea, use a COPY with a select statement : > > COPY ( select A, B,C ,D ...etc FROM table ) TO 'outfile' ; > Leaveing out the bytea column. > If this works, then then one of the bytea columns is way to big. > > Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, > 39212 > "Never attribute to malice, that which can be adequately explained by > stupidity" > - Hanlon's Razor > > > -------- Original Message -------- > Subject: Re: Trouble Upgrading Postgres > From: Tom Lane <[email protected]> > Date: Tue, November 06, 2018 11:53 am > To: Adrian Klaver <[email protected]> > Cc: Daniel Verite <[email protected]>, Charles Martin > <[email protected]>, pgsql-general > <[email protected]> > > Adrian Klaver <[email protected]> writes: > > On 11/6/18 8:27 AM, Daniel Verite wrote: > >> Adrian Klaver wrote: > >>> To me that looks like a bug, putting data into a record you cannot get > out. > > >> Strictly speaking, it could probably get out with COPY in binary format, > >> but pg_dump doesn't use that. > > Another possibility, seeing that the problematic data is bytea, is that > it might depend on whether you use hex or escape bytea_output format. > Hex format is reliably twice the size of the stored data, but escape > format could be anywhere from the same size as the stored data to four > times the size, depending on the contents. pg_dump is agnostic about this > and will just dump using the prevailing bytea_output setting, so you might > be able to get it to work by changing that setting. > > regards, tom lane > >
