pgsql: Create a FETCH_COUNT parameter that causes psql to execute

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create a FETCH_COUNT parameter that causes psql to execute
Date: 2006-08-29 22:25:12
Message-ID: 20060829222512.719EF9FB306@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Create a FETCH_COUNT parameter that causes psql to execute SELECT-like
queries via a cursor, fetching a limited number of rows at a time and
therefore not risking exhausting memory. A disadvantage of the scheme
is that 'aligned' output mode will align each group of rows independently
leading to odd-looking output, but all the other output formats work
reasonably well. Chris Mair, with some additional hacking by moi.

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
psql-ref.sgml (r1.166 -> r1.167)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/psql-ref.sgml.diff?r1=1.166&r2=1.167)
pgsql/src/bin/psql:
common.c (r1.126 -> r1.127)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/common.c.diff?r1=1.126&r2=1.127)
print.c (r1.88 -> r1.89)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/print.c.diff?r1=1.88&r2=1.89)
print.h (r1.31 -> r1.32)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/print.h.diff?r1=1.31&r2=1.32)
settings.h (r1.29 -> r1.30)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/settings.h.diff?r1=1.29&r2=1.30)
startup.c (r1.136 -> r1.137)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/startup.c.diff?r1=1.136&r2=1.137)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-08-29 22:48:55 pgsql: Dept.
Previous Message Jaime Casanova 2006-08-29 20:35:14 Re: [COMMITTERS] pgsql: Second try committing the path changes.