DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=g8S80VNQbiB1tC4buGRbL2ThhC7P6MWwVF4Xu6uQnS6R7hKNQw4ngdPABAEq8RCG6+
	N5kCZX2lq3duytrad1XsKvY4JLvfL9ALhUo7CoAzy5fMRLN771eT8zuMTSeem6SEBFZu
	19tAsuXoTPwdC0/DoFX2nJfRQm3D7ApWRirRo=
MIME-Version: 1.0
In-Reply-To: <19215.1268953178@sss.pgh.pa.us>
References: <b4399d111003181443t722285e7g463fc965511d5eb@mail.gmail.com>
	<19215.1268953178@sss.pgh.pa.us>
Date: Fri, 19 Mar 2010 07:32:16 +0100
Message-ID: <162867791003182332k33301cb0h8e317874d57e9dc7@mail.gmail.com>
Subject: Re: Emacs sql-postgres (please, sorry for question not about
	PostgreSQL).
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dmitriy Igrishin <dmitigr@gmail.com>,
	postgres list <pgsql-sql@postgresql.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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:
>> =C2=A0 =C2=A0 super=3D# 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. =C2=A0You 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

> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0regards, 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
>