Log Message: ----------- * Added dbi_link_init() function which should be fairly performant.
* dbi_link now uses the %_SHARED hash for common code including database handles. * Refactored all remote-calling code to use $_SHARED{remote_exec_dbh} * Added new SQL-callable method remote_exec() which executes on the remote side but does not return rows. * Added new facilities for examining, setting and clearing %_SHARED. * Debugging is now part of the %_SHARED hash. * Refactored the setting of pg_settings to an UPDATE. * Added version_integer() function. Thanks to Andrew of Supernews for this. I'll be using it to turn on/off features Real Soon Now. * Added checks in PL/PerlU for YAML and DATA_SOURCE. * As a consequence of the above, the dangerous, scary string eval is gone. o/` Ding, dong, the string eval is dead o/` * dbi_connection now has an environment YAML. Might want to fill this in when I get some idea of what people might want in their environments. * Because it uses spi_prepare, DBI-Link now requires PostgreSQL 8.2 (or better ;) * Added tests for mysql connectivity. Modified Files: -------------- dbi-link: README.txt (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/README.txt.diff?r1=1.6&r2=1.7) dbi_link.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/dbi_link.sql.diff?r1=1.3&r2=1.4) dbi-link/test: pg.sql (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/test/pg.sql.diff?r1=1.1&r2=1.2) Added Files: ----------- dbi-link: dump_shared.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/dump_shared.sql?rev=1.1&content-type=text/x-cvsweb-markup) scrub_shared.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/scrub_shared.sql?rev=1.1&content-type=text/x-cvsweb-markup) set_shared.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/set_shared.sql?rev=1.1&content-type=text/x-cvsweb-markup) dbi-link/test: mysql.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/test/mysql.sql?rev=1.1&content-type=text/x-cvsweb-markup) mysql.t (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/test/mysql.t?rev=1.1&content-type=text/x-cvsweb-markup) Removed Files: ------------- dbi-link: make_connection.sql (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/make_connection.sql) remote_query.sql (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dbi-link/dbi-link/remote_query.sql) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match