Re: Command-line client sometimes misinterprets tabs for - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: Command-line client sometimes misinterprets tabs for
Date
Msg-id 1030420639.33213.24.camel@jester
Whole thread Raw
In response to Command-line client sometimes misinterprets tabs for nulls  (Casey Allen Shobe <cshobe@secureworks.net>)
List pgsql-bugs
The problem is that most items in postgresql are tab completed.

Cut and past your text into a bash or zsh prompt.  It injects a bunch of
filenames into your data, as per tab completion.

Annoying, but for the benefits it's livable.


Perhaps a toggle could be created to disable tab completion?

On Mon, 2002-08-26 at 23:36, Casey Allen Shobe wrote:
> Let's say I have typed a nice formatted SQL statement like so:
>
> select        b1.blah,
>         b1.blah2,
>         b2.blah3
> from        blah_table as b1
> inner join only    blah_table2 as b2
> on        b1.blah = b2.blah;
>
> ...using tabs as the indenting medium.  Now I copy that from my editor into
> psql, and most of the tabs are converted to nulls, resulting in an error like
> "Unknown value fromblah_table".  Tabs should paste; they're normal
> characters.
>
> --
> Casey Allen Shobe / Network Security Analyst & PHP Developer
> SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
> cshobe@secureworks.net / http://www.secureworks.net
> Content is my own and does not necessarily represent my company.
>
> "Diagoras the Atheist once visited Samothrace and a friend there said to him,
> 'You think the gods have no care for humans?  Why, you can see from all these
> votive pictures here how many people have escaped the fury of storms at sea
> by praying to the gods, who have brought them safe to harbour.'  'Yes,
> indeed,' said Diagoras, 'but where are the pictures of all those who suffered
> shipwreck and perished in the waves?'  On another occasion he was on a voyage
> and the crew became anxious about the bad weather and began to mutter that it
> served them right for taking an atheist on board.  Diagoras just pointed out
> to them a number of other ships on the same course which were in equal
> difficulties and asked them whether they thought that there was a Diagoras on
> the passenger-list of every one of them.  The fact is that a man's character
> or way of life makes no difference at all to his good luck or bad."
>
> - Cicero
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

pgsql-bugs by date:

Previous
From: Grégory Faruch
Date:
Subject: jdbc example datastyle.java
Next
From: "Kristóf Kontor"
Date:
Subject: LATIN2 ORDER BY