Обсуждение: dbi-link - dbi-link: * Schema-qualified names of tables, views,
dbi-link - dbi-link: * Schema-qualified names of tables, views,
От
dfetter@pgfoundry.org (David Fetter)
Дата:
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)