Tabs and ends of lines in sql mode

Tabs and ends of lines in sql mode

[Jiri Pejchal]

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=>