pgsql: Add a new system view, pg_prepared_statements, that can be used

Поиск
Список
Период
Сортировка
От neilc@postgresql.org (Neil Conway)
Тема pgsql: Add a new system view, pg_prepared_statements, that can be used
Дата
Msg-id 20060108070027.412F59DC842@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Add a new system view, pg_prepared_statements, that can be used to
access information about the prepared statements that are available
in the current session. Original patch from Joachim Wieland, various
improvements by Neil Conway.

The "statement" column of the view contains the literal query string
sent by the client, without any rewriting or pretty printing. This
means that prepared statements created via SQL will be prefixed with
"PREPARE ... AS ", whereas those prepared via the FE/BE protocol will
not. That is unfortunate, but discussion on -patches did not yield an
efficient way to improve this, and there is some merit in returning
exactly what the client sent to the backend.

Catalog version bumped, regression tests updated.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        catalogs.sgml (r2.115 -> r2.116)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.115&r2=2.116)
    pgsql/doc/src/sgml/ref:
        prepare.sgml (r1.16 -> r1.17)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/prepare.sgml.diff?r1=1.16&r2=1.17)
    pgsql/src/backend/catalog:
        system_views.sql (r1.22 -> r1.23)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.22&r2=1.23)
    pgsql/src/backend/commands:
        prepare.c (r1.44 -> r1.45)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/prepare.c.diff?r1=1.44&r2=1.45)
    pgsql/src/backend/tcop:
        postgres.c (r1.477 -> r1.478)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/postgres.c.diff?r1=1.477&r2=1.478)
    pgsql/src/include/catalog:
        catversion.h (r1.308 -> r1.309)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.308&r2=1.309)
        pg_proc.h (r1.389 -> r1.390)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.389&r2=1.390)
        pg_type.h (r1.167 -> r1.168)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_type.h.diff?r1=1.167&r2=1.168)
    pgsql/src/include/commands:
        prepare.h (r1.16 -> r1.17)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/prepare.h.diff?r1=1.16&r2=1.17)
    pgsql/src/include/utils:
        builtins.h (r1.268 -> r1.269)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h.diff?r1=1.268&r2=1.269)
    pgsql/src/test/regress/expected:
        prepare.out (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/prepare.out.diff?r1=1.5&r2=1.6)
        rules.out (r1.110 -> r1.111)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.110&r2=1.111)
    pgsql/src/test/regress/sql:
        prepare.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/prepare.sql.diff?r1=1.2&r2=1.3)

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

Предыдущее
От: fxjr@pgfoundry.org (User Fxjr)
Дата:
Сообщение: npgsql - Npgsql: 2006-01-07 Francisco Figueiredo Jr.
Следующее
От: luf@pgfoundry.org (User Luf)
Дата:
Сообщение: psqlodbc - psqlodbc: call RALLBACK with bad stmt only when autocommit is