Re: [GENERAL] Annoying messages when copy sql code to psql terminal

2008-06-06 Thread Reece Hart
On Thu, 2008-06-05 at 22:28 -0400, Merlin Moncure wrote: > 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. Tabs in SQL are a problem only if you copy-paste. If your editor and psql can see the s

Re: [GENERAL] Annoying messages when copy sql code to psql terminal

2008-06-06 Thread Scott Marlowe
On Fri, Jun 6, 2008 at 6:12 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote: > On Fri, Jun 6, 2008 at 12:39 AM, Gurjeet Singh <[EMAIL PROTECTED]> wrote: >> On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote: >>> As others have noted, you have tabs in your sql source. I'd advise

Re: [GENERAL] Annoying messages when copy sql code to psql terminal

2008-06-06 Thread Merlin Moncure
On Fri, Jun 6, 2008 at 12:39 AM, Gurjeet Singh <[EMAIL PROTECTED]> wrote: > On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote: >> 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 >> rea

Re: [GENERAL] Annoying messages when copy sql code to psql terminal

2008-06-05 Thread Gurjeet Singh
On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote: > On Tue, May 27, 2008 at 9:24 AM, A B <[EMAIL PROTECTED]> 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

Re: [GENERAL] Annoying messages when copy sql code to psql terminal

2008-06-05 Thread Merlin Moncure
On Tue, May 27, 2008 at 9:24 AM, A B <[EMAIL PROTECTED]> 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 > > ABORTCHECKPOINT COMMIT DECLARE EXECUTE [...] As

Re: [GENERAL] Annoying messages when copy sql code to psql terminal

2008-06-05 Thread Alvaro Herrera
Tom Lane escribió: > "A B" <[EMAIL PROTECTED]> writes: > > Whenever I use copy-paste to run code in a terminal window that is > > running psql, and the code contains a row like > > [...] > Either avoid copying/pasting tabs, or turn off readline > (-n option to psql, I think, but check the manual).