pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
psql 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>
  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 15:43  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Marius Andreiana <marius@wdg.ro>
  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 16:12  Peter Eisentraut <peter_e@gmx.net>
  parent: Marius Andreiana <marius@wdg.ro>
  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 16:17  Peter Eisentraut <peter_e@gmx.net>
  parent: 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