[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Tabs and ends of lines in sql mode
From: |
Jiri Pejchal |
Subject: |
Tabs and ends of lines in sql mode |
Date: |
Sat, 22 Apr 2006 19:31:40 +0200 |
User-agent: |
Gnus/5.11 (Gnus v5.11) Emacs/22.0.50 (gnu/linux) |
The function sql-send-paragraph in sql.el sends current paragraph to the
SQL process. However it sends the paragraph with leading tabs and ends
of lines. In database front-ends like mysql or psql tabs are bound to
completion and so the completion is printed. Moreover ends of lines
cause secondary prompts to be printed.
So if I send:
create table stock (
id int4,
avail int4,
ordered int4,
valid bool,
description text
);
six secondary prompts and five times the completions (several lines) are
printed, that is very inconvenient.
Could sql mode not send the internal tabs and ends of lines?
Jiri Pejchal
Sending the previous example produces following output:
test=> test(>
ABORT COMMIT END LISTEN RELEASE SHOW
ALTER COPY EXECUTE LOAD RESET START
ANALYZE CREATE EXPLAIN LOCK REVOKE TRUNCATE
BEGIN DEALLOCATE FETCH MOVE ROLLBACK UNLISTEN
CLOSE DECLARE GRANT NOTIFY SAVEPOINT UPDATE
CLUSTER DELETE FROM CHECKPOINT PREPARE SELECT VACUUM
COMMENT DROP INSERT REINDEX SET
test(>
ABORT COMMIT END LISTEN RELEASE SHOW
ALTER COPY EXECUTE LOAD RESET START
ANALYZE CREATE EXPLAIN LOCK REVOKE TRUNCATE
BEGIN DEALLOCATE FETCH MOVE ROLLBACK UNLISTEN
CLOSE DECLARE GRANT NOTIFY SAVEPOINT UPDATE
CLUSTER DELETE FROM CHECKPOINT PREPARE SELECT VACUUM
COMMENT DROP INSERT REINDEX SET
test(>
ABORT COMMIT END LISTEN RELEASE SHOW
ALTER COPY EXECUTE LOAD RESET START
ANALYZE CREATE EXPLAIN LOCK REVOKE TRUNCATE
BEGIN DEALLOCATE FETCH MOVE ROLLBACK UNLISTEN
CLOSE DECLARE GRANT NOTIFY SAVEPOINT UPDATE
CLUSTER DELETE FROM CHECKPOINT PREPARE SELECT VACUUM
COMMENT DROP INSERT REINDEX SET
test(>
ABORT COMMIT END LISTEN RELEASE SHOW
ALTER COPY EXECUTE LOAD RESET START
ANALYZE CREATE EXPLAIN LOCK REVOKE TRUNCATE
BEGIN DEALLOCATE FETCH MOVE ROLLBACK UNLISTEN
CLOSE DECLARE GRANT NOTIFY SAVEPOINT UPDATE
CLUSTER DELETE FROM CHECKPOINT PREPARE SELECT VACUUM
COMMENT DROP INSERT REINDEX SET
test(>
ABORT COMMIT END LISTEN RELEASE SHOW
ALTER COPY EXECUTE LOAD RESET START
ANALYZE CREATE EXPLAIN LOCK REVOKE TRUNCATE
BEGIN DEALLOCATE FETCH MOVE ROLLBACK UNLISTEN
CLOSE DECLARE GRANT NOTIFY SAVEPOINT UPDATE
CLUSTER DELETE FROM CHECKPOINT PREPARE SELECT VACUUM
COMMENT DROP INSERT REINDEX SET
test(> CREATE TABLE
test=>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- Tabs and ends of lines in sql mode,
Jiri Pejchal <=