psql paste weirdness

From: John Smith <john_smith_45678(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: psql paste weirdness
Date: 2003-01-26 21:48:29
Message-ID: 20030126214829.79320.qmail@web40711.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin


When pasting certain SQL commands into psql in the cygwin window, it beeps and prints a list of some SQL commands.

This SQL:

create or replace view v_software as
select s.id,
s.title,
(s.version_major || '.' || s.version_minor || '.' || s.version_revision) as version,
d.user_id
from software s
inner join downloads d
on s.id = d.software_id
order by title;

Results in this output:

pg=> create or replace view v_software as
pg-> select s.id,
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
pg-> s.title,
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
<| s.version_minor || '.' || s.version_revision) as version,
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
pg-> d.user_id
pg-> from software s
pg-> inner join download d
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
pg-> on s.id = d.software_id
pg-> order by title;
CREATE VIEW

I've tried saving the file I'm copying from as both unix and windows formats.

---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Browse pgsql-cygwin by date

  From Date Subject
Next Message Justin Clift 2003-01-27 02:00:39 Re: postmaster does not shut down
Previous Message John Smith 2003-01-26 21:10:37 postmaster does not shut down