Alvaro Herrera <alvhe...@commandprompt.com> writes: > I am not sure about the idea of letting the detail run to the end of the > line; that would be problematic should the line be long (there might not > be newlines in the literal at all, which is not that unusual). I think > it should be truncated at, say, 76 chars or so.
Yeah, I was wondering about trying to provide a given amount of context instead of fixing it to "one line". We could do something like (1) back up N characters; (2) find the next newline, if there is one at least M characters before the error point; (3) print from there to the error point. This would give between M and N characters of context, except when the error point is less than M characters from the start of the input. Not sure how to display such text together with a line number though; with a multi-line fragment it would not be obvious which part the line number refers to. (Backing up over multibyte data might be a bit complicated too, but I assume we can think of something workable for that.) 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