General Bug Report: Buffer query in MainLoop of psql is never flushed

Поиск
Список
Период
Сортировка
От Unprivileged user
Тема General Bug Report: Buffer query in MainLoop of psql is never flushed
Дата
Msg-id 199901181403.JAA08685@hub.org
обсуждение исходный текст
Список pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Leif Jakob
Your email address    : jakob@weite-welt.com

Category        : runtime: front-end
Severity        : serious

Summary: Buffer query in MainLoop of psql is never flushed

System Configuration
--------------------
  Operating System   : Linux ELF

  PostgreSQL version : 6.4.2

  Compiler used      : gcc

Hardware:
---------
P 120
but doesn't matter

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
The buffer query passed as a parameter to MainLoop in the
program psql is never flushed after a query, so the buffer
will grow until it reaches the maximum size and the tool
will refuse any query.

--------------------------------------------------------------------------

Test Case:
----------
Pipe a SQL-Script with more than 20k to psql.

--------------------------------------------------------------------------

Solution:
---------
After a very quick look i patched all places where
querySend is set true with the line:
query[0]=0;



--------------------------------------------------------------------------


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Javier Kohen
Дата:
Сообщение: create view foo as select avg(x), avg(y) from bar; "ERROR: attribute 'avg' duplicated" BUG or FEATURE?
Следующее
От: Unprivileged user
Дата:
Сообщение: General Bug Report: Problem Deleting VIEWS