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

Started by Nonamealmost 20 years ago1 messagescomitters
Jump to latest
#1Noname
dfetter@pgfoundry.org

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)