2010/3/18 Tom Lane <t...@sss.pgh.pa.us>: > Dmitriy Igrishin <dmit...@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 > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
