pg_dump truncating queries in error messages

Started by Peter Eisentrautalmost 9 years ago3 messages
#1Peter Eisentraut
peter.eisentraut@2ndquadrant.com

When reporting an error from a query, pg_dump truncates the reported
query to 128 characters (pg_backup_db.c ExecuteSqlCommand()).

Is this (still) sensible? The kind of queries that pg_dump is running
nowadays, I find myself unable to debug them if they are truncated at
that length.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Eisentraut (#1)
Re: pg_dump truncating queries in error messages

Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:

When reporting an error from a query, pg_dump truncates the reported
query to 128 characters (pg_backup_db.c ExecuteSqlCommand()).

Is this (still) sensible? The kind of queries that pg_dump is running
nowadays, I find myself unable to debug them if they are truncated at
that length.

Not clear that it ever was very sensible ... +1 for removing the limit.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Peter Eisentraut
peter.eisentraut@2ndquadrant.com
In reply to: Tom Lane (#2)
Re: pg_dump truncating queries in error messages

On 3/26/17 16:09, Tom Lane wrote:

Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:

When reporting an error from a query, pg_dump truncates the reported
query to 128 characters (pg_backup_db.c ExecuteSqlCommand()).

Is this (still) sensible? The kind of queries that pg_dump is running
nowadays, I find myself unable to debug them if they are truncated at
that length.

Not clear that it ever was very sensible ... +1 for removing the limit.

OK done.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers