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

From: dfetter(at)pgfoundry(dot)org (David Fetter)
To: pgsql-committers(at)postgresql(dot)org
Subject: dbi-link - dbi-link: * Schema-qualified names of tables, views,
Date: 2006-10-11 23:39:33
Message-ID: 20061011233933.BFD3186CBD6@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-10-11 23:45:54 Re: [COMMITTERS] pgsql: Repair incorrect check for coercion of unknown literal to
Previous Message Bruce Momjian 2006-10-11 23:01:46 pgsql: Update pg_hba.conf comment about documentation section.