Re: Patch: show relation and tuple infos of a lock to acquire - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Patch: show relation and tuple infos of a lock to acquire
Date
Msg-id 20140303100842.GA23352@awork2.anarazel.de
Whole thread Raw
In response to Re: Patch: show relation and tuple infos of a lock to acquire  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Patch: show relation and tuple infos of a lock to acquire
List pgsql-hackers
On 2014-02-28 20:55:20 +0530, Amit Kapila wrote:
> On Thu, Feb 27, 2014 at 4:14 PM, Christian Kruse
> >> I wouldn't be inclined to dump the whole tuple under any
> >> circumstances.  That could be a lot more data than what you want
> >> dumped in your log.  The PK could already be somewhat unreasonably
> >> large, but the whole tuple could be a lot more unreasonably large.
> >
> > Well, as I already stated: we don't. I copied the behavior we use in
> > CHECK constraints (ExecBuildSlotValueDescription()).
> 
> I think now more people are of opinion that displaying whole tuple is
> not useful. I believe it is good to go ahead by displaying just primary key
> for this case and move ahead.

The patch does not, and has never, printed the full tuple. What it does
is copying the behaviour of printing the tuple for check constraint
violations, which is truncating the tuple after a certain length.

I don't think changing this in an isolated manner to the primary key
would be a good idea. Let's use the same logic here, and if somebody
wants to argue for always using the primary key instead of a truncated
tuple, let them submit a separate patch.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Get more from indices.
Next
From: Andres Freund
Date:
Subject: Re: Patch: show relation and tuple infos of a lock to acquire