From: Pavel Stehule <pavel.stehule@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dmitriy Igrishin <dmitigr@gmail.com>
Cc: postgres list <pgsql-sql@postgresql.org>
Subject: Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
Date: Fri, 19 Mar 2010 07:32:16 +0100
Message-ID: <162867791003182332k33301cb0h8e317874d57e9dc7@mail.gmail.com> (raw)
In-Reply-To: <19215.1268953178@sss.pgh.pa.us>
References: <b4399d111003181443t722285e7g463fc965511d5eb@mail.gmail.com>
<19215.1268953178@sss.pgh.pa.us>
2010/3/18 Tom Lane <tgl@sss.pgh.pa.us>:
> Dmitriy Igrishin <dmitigr@gmail.com> writes:
>> I am using Emacs recently. I love sql-mode, to use with PostgreSQL,
>> but I have problems with it.
>> When my SQL file (or buffer) are small (50-100 lines) I can send
>> it to SQLi buffer without any problems. But when I working with
>> large SQL file (e.g. complex database model, thousands of lines)
>> and send it to SQLi buffer it does not work properly. Something
>> going on and in SQLi buffer (psql) I see incomplete SQL
>> statement, for example:
>> super=# super'# super'# super'# super'#
>> It seems to single quote was not closed. But SQL is absolutely
>> correct and loads fine when I load it from file directly from psql.
>> I think, the problem with Emacs buffers... Please, help!
>
> Might or might not be related, but I've seen psql lock up when I try to
> paste more than a thousand or two characters into it via X11
> copy-and-paste. You might find that disabling libreadline (option -n
> to psql) helps.
>
This behave is same without external copy/paste. SQL support in emacs
is really great with some issues - like this or missing autocomplete.
Pavel
> regards, tom lane
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pavel.stehule@gmail.com, tgl@sss.pgh.pa.us, dmitigr@gmail.com
Subject: Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
In-Reply-To: <162867791003182332k33301cb0h8e317874d57e9dc7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox