flightaware/Pgtcl v1.6

PgTcl 1.6

on GitHub

* Add pg_null_value_string, ::pg::null_value_string and
  "$conn null_value_string" to get and set a special string value that
  will be returned for fields containing null values from queries.

  pg_select and pg_execute use this value for null values.  If not set,
  they use the traditional empty string.

  pg_exec, pg_exec_prepared, pg_sendquery and pg_sendquery_prepared use
  this value as well.  However, it can be overridden or replaced for
  one specific result using "pg_result $result -null_value_string NULL",
  etc, or by executing the result handle, as in
  "$result -null_value_string NULL"

  Updated documentation and regenerated HTML and PDF files.

* List -cmdTuples as one of the possible options when executing
  pg_result without arguments.

* Made pggrok database introspection code much more useful -- routines
  for finding out data about fields and indexes in a table now load
  on array with data about each field (index) and execute a code body
  on it, rather than punting with a call to parray

* Fixed memory leaks when connections-as-commands are used
  ($conn exec $statement, etc)

* added more documentation about the new capabilities

* took away pg::conninfo and pg::results, and made one command
  pg::dbinfo. Usage is pg::dbinfo connections and
  pg::dbinfo results $conn

* Document pg_exec_prepared, pg_results, and pg_sendquery_prepared.

* Document pg_exec's ability to take optional arguments for
  $-substitution in PostgreSQL 7.4+.

* Documented pg_getresult and pg_result -error suboptions.

* Pasted connect string options from the libpq manual rather
  than simply referring Pgtcl users to the libpq manual.

* Regenerated pdf and html documentation.

* Added commands to escape and unescape binary strings

* Added library of useful PostreSQL helper functions to the playpen.

* Added dbobjects PostgreSQL/Itcl-object interface package to the playpen.

* Added pggrok code to introspect into Postgres databases to the playpen.

* Simplify result object processing

* Fixed bug in Pg_cancelrequest where the error message would
  not be returned.

* Remove unused variables.

* Silence compiler warnings about a fall-through (that couldn't
  be reached) that would cause a function declared to return something
  to not return anything and about a possibly uninitialized variable.

* Created playpen directory where interesting things that are not
  yet ready for prime time can be examined and messed with.
  Added code for turning OIDs returned by pg_result -lAttributes
  into data type names.

* Updated autoconf build to TEA 3.1 / autoconf 2.59

* Added import_sampledata_prepared_onetransaction.tcl to the tests

* minor optimization in connections-as-commands and results-as-commands
  where we don't copy and then swap, we copy it the way we want it to
  end up (first and second elements of objv reversed).

* connections-as-commands and results-as-commands now error out when
  called with no arguments

* libpgtcl will again build with versions of Tcl < 8.5 thanks to a little
  extra checking for HAVETCL_NEWDICTOBJ

* Fixed several calls to Tcl_AppendStringsToObj whose arguments were
  terminated with -1 instead of NULL, eliminating several segmentation
  violations that could occur while preparing error messages.

* Removed spurious newline at the start of the error message when
  the query result handle passed to pg_result is invalid.

* added delete proc for result handle cleanup

* added delete proc for connection handle cleanup