Re: Annoying messages when copy sql code to psql terminal

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "A B" <gentosaker(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Annoying messages when copy sql code to psql terminal
Date: 2008-06-06 02:28:42
Message-ID: b42b73150806051928y6b12d775xe2d4de138d1a5fd3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 27, 2008 at 9:24 AM, A B <gentosaker(at)gmail(dot)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.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Winter 2008-06-06 03:02:07 Extracting data from deprecated MONEY fields
Previous Message Ati Rosselet 2008-06-06 01:39:57 Application EventLog: could not write to log file: Bad file descriptor