dbi-link - dbi-link: * Schema-qualified names of tables, views,

Поиск
Список
Период
Сортировка
От dfetter@pgfoundry.org (David Fetter)
Тема dbi-link - dbi-link: * Schema-qualified names of tables, views,
Дата
Msg-id 20061011233933.BFD3186CBD6@pgfoundry.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
* Schema-qualified names of tables, views, functions, etc.

* Lowered minimum version of pg to 8.1.4.

* Moved environment_yaml from dbi_connection to its own table, as it's
  not a tree structure.

* Added table dbi_connection_environment.  XXX Currently unused.

* Added function add_dbi_connection_environment which takes a
  data_source_id and an environment YAML and stuffs the result into
  dbi_connection_environment.  XXX Currently unused.

* Created dbi_link.yaml_result_set which serializes a result set into
  YAML.  Used in making VIEW (below) dbi_link.dbi_all_connection_info
  writeable.

* Created VIEW dbi_link.dbi_all_connection_info which rolls
  dbi_connection and dbi_connection_environment into one rowset.

* Made VIEW dbi_link.dbi_all_connection_info writeable.

* Put min_pg_version and server_version into %_SHARED hash in
  dbi_link_init()

* Added check for minimum version, bails out if not.

* Change dbh_attr to dbh_attributes all the way through.

* Added a way to set environment variables if they're there in
  dbi_connection_environment.

* Added quote_ident and quote_literal perl methods to the %_SHARED
  hash.

* Changed shadow_trigger_function to:

  - use dbi_link.dbi_link_init() instead of DBI directly.

  - refactor for correctness and easier debuggability.

* Broke out set_up_connection function so it can be called from >1
  place.

* Finished back-port to 8.1x.

* Broke out dbi_link.create_schema into its own function.

* Broke out create_accessor_methods into its own function.

  - Removed no-longer-needed CREATE TYPE section.

  - Refactored automatic creation of INSERT, UPDATE and DELETE RULEs.

* Pulled out make_accessor_functions and made it callable from SQL.

* Created new function dbi_link.refresh_schema(data_source_id),
  callable from SQL.  This works when you've dropped the local_schema
  to which that data_source_id refers in dbi_link.dbi_connection.
  XXX TODO: Make this drop the schema and re-create it if it needs to.

Modified Files:
--------------
    dbi-link:
        dbi_link.sql (r1.5 -> r1.6)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/dbi_link.sql.diff?r1=1.5&r2=1.6)

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

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Update pg_hba.conf comment about documentation section.
Следующее
От: h-saito@pgfoundry.org (User H-saito)
Дата:
Сообщение: psqlodbc - psqlodbc: Fixed DRIVER_FILE_NAME for *nix.