From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Minor bug: Odd feedback on STDERR from PSQL for block comments |
Date: | 2003-11-07 23:53:22 |
Message-ID: | 200311071553.22067.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Guys,
Here's a non-showstopper in 7.4RC1, but probably good to fix before RC2:
(btw, tested & exists on beta4 as well, so I'm not sure when it was
introduced)
1) Create a file with *only* a block comment in it, or with a block comment as
the very last line.
2) run psql -f filename database
You will get some odd feedback on STDERR:
on Linux, file with only a block comment:
josh(at)temoku:~/Documents/oss/postgres> psql -f tempit2.sql -U postgres test1
psql:tempit2.sql:1: josh(at)temoku:~/Documents/oss/postgres>
on OSX:
josh% /usr/local/pgsql/bin/psql -U postgres -f ~/test.sql sharky
psql:/Users/josh/test.sql:1: [mercury:~] josh%
on Linux, file with several commands, ending in a block comment:
josh(at)temoku:~/Documents/oss/postgres/phpcon> psql -f tempit.sql -U postgres
test1
CREATE TABLE
INSERT 17168 1
INSERT 17169 1
INSERT 17170 1
psql:tempit.sql:13: ERROR: column "iddomain" does not exist
DELETE 1
psql:tempit.sql:18: josh(at)temoku:~/Documents/oss/postgres/phpcon>
I'm not sure why we're getting a line header ("psql:tempit2.sql:1: ") on an
empty line, but it's annoying for any application writer (Bricolage) looking
for failure messages on STDERR.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | bvctravel | 2003-11-08 02:57:12 | postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables |
Previous Message | Przemysław | 2003-11-07 22:46:21 | COPY and sequences |