Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL). - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
Date
Msg-id 162867791003182332k33301cb0h8e317874d57e9dc7@mail.gmail.com
Whole thread Raw
In response to Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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
>


pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
Next
From: Gurjeet Singh
Date:
Subject: Re: Linked list with CTE