pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql bug: copy paste statements looses tab character
5+ messages / 4 participants
[nested] [flat]
* psql bug: copy paste statements looses tab character
@ 2002-01-14 18:00 Marius Andreiana <marius@webdevgroup.com>
0 siblings, 0 replies; 5+ messages in thread
From: Marius Andreiana @ 2002-01-14 18:00 UTC (permalink / raw)
To: pgsql-sql
this happens in 7.1.3 (included in red hat 7.2).
e.g.
CREATE TABLE items (
item_id SERIAL,
name VARCHAR(32)
);
copy pasted in psql gives this
marius=> CREATE TABLE items (
marius(> item_id
marius(> item_idSERIAL,
marius(> name
marius(> nameVARCHAR(32)
marius(> );
ERROR: parser: parse error at or near "("
this will work:
CREATE TABLE items (
item_id SERIAL,
name VARCHAR(32)
);
I've seen this behavior on sybase's sqsh once, perhaps it's something
system wide, and not psql's fault?
--
Marius Andreiana
Web Development Group, Inc.
^ permalink raw reply [nested|flat] 5+ messages in thread
* psql bug: copy paste statements looses tab character
@ 2002-01-16 07:15 Marius Andreiana <marius@wdg.ro>
2002-01-16 15:43 ` Re: psql bug: copy paste statements looses tab character Tom Lane <tgl@sss.pgh.pa.us>
2002-01-16 16:12 ` Re: psql bug: copy paste statements looses tab character Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 5+ messages in thread
From: Marius Andreiana @ 2002-01-16 07:15 UTC (permalink / raw)
To: pgsql-sql
this happens in 7.1.3 (included in red hat 7.2).
e.g.
CREATE TABLE items (
item_id SERIAL,
name VARCHAR(32)
);
copy pasted in psql gives this
marius=> CREATE TABLE items (
marius(> item_id
marius(> item_idSERIAL,
marius(> name
marius(> nameVARCHAR(32)
marius(> );
ERROR: parser: parse error at or near "("
this will work:
CREATE TABLE items (
item_id SERIAL,
name VARCHAR(32)
);
I've seen this behavior on sybase's sqsh once, perhaps it's something
system wide, and not psql's fault?
--
Marius Andreiana
--
You don't have to go to jail for helping your neighbour
http://www.gnu.org/philosophy/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: psql bug: copy paste statements looses tab character
2002-01-16 07:15 psql bug: copy paste statements looses tab character Marius Andreiana <marius@wdg.ro>
@ 2002-01-16 15:43 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2002-01-16 15:43 UTC (permalink / raw)
To: Marius Andreiana <marius@wdg.ro>; +Cc: pgsql-sql
Marius Andreiana <marius@wdg.ro> writes:
> I've seen this behavior on sybase's sqsh once, perhaps it's something
> system wide, and not psql's fault?
Tab triggers word completion in psql. If you don't want this, disable
readline support when you start psql (psql -n). It might be possible
to turn off word completion without losing other readline features;
not sure.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: psql bug: copy paste statements looses tab character
2002-01-16 07:15 psql bug: copy paste statements looses tab character Marius Andreiana <marius@wdg.ro>
@ 2002-01-16 16:12 ` Peter Eisentraut <peter_e@gmx.net>
2002-01-16 16:17 ` Re: psql bug: copy paste statements looses tab character Peter Eisentraut <peter_e@gmx.net>
1 sibling, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2002-01-16 16:12 UTC (permalink / raw)
To: Marius Andreiana <marius@wdg.ro>; +Cc: pgsql-sql
Marius Andreiana writes:
> I've seen this behavior on sybase's sqsh once, perhaps it's something
> system wide, and not psql's fault?
It's definitely something in your terminal driver. Some X terminal
implementations are really bad at being able to copy funny characters.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: psql bug: copy paste statements looses tab character
2002-01-16 07:15 psql bug: copy paste statements looses tab character Marius Andreiana <marius@wdg.ro>
2002-01-16 16:12 ` Re: psql bug: copy paste statements looses tab character Peter Eisentraut <peter_e@gmx.net>
@ 2002-01-16 16:17 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 5+ messages in thread
From: Peter Eisentraut @ 2002-01-16 16:17 UTC (permalink / raw)
To: Marius Andreiana <marius@wdg.ro>; +Cc: pgsql-sql
I wrote:
> Marius Andreiana writes:
>
> > I've seen this behavior on sybase's sqsh once, perhaps it's something
> > system wide, and not psql's fault?
>
> It's definitely something in your terminal driver. Some X terminal
> implementations are really bad at being able to copy funny characters.
Cancel that. Of course it's the tab completion. I just have really bad
experiences with terminal drivers. :-(
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-01-16 16:17 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-14 18:00 psql bug: copy paste statements looses tab character Marius Andreiana <marius@webdevgroup.com>
2002-01-16 07:15 psql bug: copy paste statements looses tab character Marius Andreiana <marius@wdg.ro>
2002-01-16 15:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-16 16:12 ` Peter Eisentraut <peter_e@gmx.net>
2002-01-16 16:17 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox