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)
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. |