From: | Erwin Brandstetter <brandstetter(at)falter(dot)at> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | v.1.6.2: issue with truncated column comments. |
Date: | 2007-01-08 23:46:24 |
Message-ID: | 45A2D7D0.8@falter.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi developers! Hi Dave!
Testing pgAdmin III v1.6.2 rev: 5837, client Win XP. Host Debian Sarge,
PG 8.1.4.
While having a look at the new release, I think I found an issue with
truncated column comments. It seemed quite random at first, I guess I
have figured it out, though:
If the comment includes a windows-style linebreak (CR+LF), the appended
dots end up in a new line. The generated script is not executable
without syntax error.
Does not happen with Linx-style linebreak (LF). Not tested with
Max-style (CR).
Show-case appended.
Sorry I did not report earlier, I did not have access to a windows build
before release, though.
On a sidenote: appending ' ..' (a blank and 2 or 3 dots) might look
cleaner than '...' (3 dots, no blank).
Regards
Erwin
-- Table: test
-- DROP TABLE test;
CREATE TABLE test
(
a text, -- a
b text, -- b...
c text -- c
...
)
WITHOUT OIDS;
ALTER TABLE test OWNER TO postgres;
COMMENT ON COLUMN test.a IS 'a';
COMMENT ON COLUMN test.b IS 'b
c linebreak = LF (Linux)';
COMMENT ON COLUMN test.c IS 'c
d linebreak = CR+LF (Windows)';
From | Date | Subject | |
---|---|---|---|
Next Message | rdelong | 2007-01-08 23:56:12 | problem with pgadmin query tool EOL sequences |
Previous Message | Milen A. Radev | 2007-01-08 19:32:47 | SQL Window's Title |