From: Tom Lane <tgl@sss.pgh.pa.us>
To: 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: Thu, 18 Mar 2010 18:59:38 -0400
Message-ID: <19215.1268953178@sss.pgh.pa.us> (raw)
In-Reply-To: <b4399d111003181443t722285e7g463fc965511d5eb@mail.gmail.com>
References: <b4399d111003181443t722285e7g463fc965511d5eb@mail.gmail.com>
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.
regards, tom lane
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: tgl@sss.pgh.pa.us, dmitigr@gmail.com
Subject: Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
In-Reply-To: <19215.1268953178@sss.pgh.pa.us>
* 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