Re: Annoying messages when copy sql code to psql terminal

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Annoying messages when copy sql code to psql terminal
Дата
Msg-id 65937bea0806052139i1f6b9613qd07166bfe30c031d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Annoying messages when copy sql code to psql terminal  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы Re: Annoying messages when copy sql code to psql terminal  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
On Tue, May 27, 2008 at 9:24 AM, A B <gentosaker@gmail.com> wrote:
> Whenever I use copy-paste to run code in a terminal window that is
> running psql, and the code contains a row like
>
> IF FOUND THEN
>
> then I get the words
>
> ABORT        CHECKPOINT   COMMIT       DECLARE      EXECUTE

[...]

As others have noted, you have tabs in your sql source.  I'd advise if
possible, not to use the tab character in sql, for this and other
reasons.

Can you please elaborate on other reasons? I have never encountered any _other_ reason!!

And 'using psql' is not reason enough to not indent your SQL code.

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Extracting data from deprecated MONEY fields
Следующее
От: "Brent Wood"
Дата:
Сообщение: Re: Temporary Tables and Web Application