pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedEmacs sql-postgres (please, sorry for question not about PostgreSQL).
5+ messages / 4 participants
[nested] [flat]
* Emacs sql-postgres (please, sorry for question not about PostgreSQL).
@ 2010-03-18 21:43 Dmitriy Igrishin <dmitigr@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: Dmitriy Igrishin @ 2010-03-18 21:43 UTC (permalink / raw)
To: pgsql-sql
Hello all Emacs users!
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!
And please sorry, for question not about PostgreSQL...
Regards,
Dmitriy Igrishin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
@ 2010-03-18 22:18 Hiltibidal, Rob <Rob.Hiltibidal@argushealth.com>
parent: Dmitriy Igrishin <dmitigr@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Hiltibidal, Rob @ 2010-03-18 22:18 UTC (permalink / raw)
To: Dmitriy Igrishin <dmitigr@gmail.com>; pgsql-sql
I recommend switching to aqua data studio
I can query mysql, postgres, db2, oracle with the same tool
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Dmitriy Igrishin
Sent: Thursday, March 18, 2010 4:44 PM
To: postgres list
Subject: [SQL] Emacs sql-postgres (please, sorry for question not about
PostgreSQL).
Hello all Emacs users!
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!
And please sorry, for question not about PostgreSQL...
Regards,
Dmitriy Igrishin
PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
@ 2010-03-18 22:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dmitriy Igrishin <dmitigr@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2010-03-18 22:59 UTC (permalink / raw)
To: Dmitriy Igrishin <dmitigr@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
@ 2010-03-19 06:30 Pavel Stehule <pavel.stehule@gmail.com>
parent: Dmitriy Igrishin <dmitigr@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Pavel Stehule @ 2010-03-19 06:30 UTC (permalink / raw)
To: Dmitriy Igrishin <dmitigr@gmail.com>; +Cc: pgsql-sql
Hello
try to look on http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Terminal.27s_configuration
Regards
Pavel Stehule
2010/3/18 Dmitriy Igrishin <dmitigr@gmail.com>:
> Hello all Emacs users!
>
> 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!
>
> And please sorry, for question not about PostgreSQL...
>
> Regards,
> Dmitriy Igrishin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL).
@ 2010-03-19 06:32 Pavel Stehule <pavel.stehule@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Pavel Stehule @ 2010-03-19 06:32 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Dmitriy Igrishin <dmitigr@gmail.com>; 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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-03-19 06:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-18 21:43 Emacs sql-postgres (please, sorry for question not about PostgreSQL). Dmitriy Igrishin <dmitigr@gmail.com>
2010-03-18 22:18 ` Hiltibidal, Rob <Rob.Hiltibidal@argushealth.com>
2010-03-18 22:59 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-19 06:32 ` Pavel Stehule <pavel.stehule@gmail.com>
2010-03-19 06:30 ` Pavel Stehule <pavel.stehule@gmail.com>
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