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,
> 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
> Casey Allen Shobe / Network Security Analyst & PHP Developer
> SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
> cshobe(at)secureworks(dot)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(at)postgresql(dot)org)
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-08-27 05:48:33|
|Subject: Re: Command-line client sometimes misinterprets tabs for nulls |
|Previous:||From: Casey Allen Shobe||Date: 2002-08-27 03:36:15|
|Subject: Command-line client sometimes misinterprets tabs for nulls|