Comments cut off after line break

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-support(at)postgresql(dot)org
Subject: Comments cut off after line break
Date: 2006-12-06 19:26:57
Message-ID: 45771981.5010106@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi developers! Hi Dave!

Using pgAdmin III v1.6.1 rev: 5709, client Win XP. Host Debian Sarge, PG
8.1.4.

In the object browser comments are appended to the columns of a table
definition, which is useful.
But it looks like those comments are cut off after the first line break.
Simple test case:

CREATE TABLE test
(
a integer -- First line of comment
)
WITHOUT OIDS;

COMMENT ON COLUMN test.a IS 'First line of comment
Second line.
Third line of comment.';

psql gives unabbreviated comments:
\d+ test

Maybe this happens on purpose to shorten lengthy comments. But then
again, a better way would probably be to print the first x (200?)
characters (substituting spaces for linebreaks) and append ' ...' if
there is more.
This is not a major problem, but misleading sometimes. Might be easy to fix.
I remember similar (graver) problems with line breaks in 1.6 beta, which
you fixed. Looks like this one got away.

Regards
Erwin

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Erwin Brandstetter 2006-12-06 20:26:16 Precision modifier for time-types displayed incorrectly
Previous Message Dave Page 2006-12-06 16:49:52 Re: Backup of rules