Autodoc - Release Notes

Fix named function support. DBD::Pg change the way it works and need to follow. ( Rod)

Add -m <regex> to output structure or functions matching a specific regular expression. The expression is interpreted by PostgreSQL. (Simon Michael)

Simplify the makefile. To target a prefix use make PREFIX=? install. Configure and automake uses have been removed. (Simon Bertrang)

Remove support for PostgreSQL 7.4 and earlier. Simplify queries and code. ( Rod)

Improve --table help. (Jamie Nicholson)

Change --tables to be a list of tables instead of singular. ( Leonardo)

Do not attempt to retrieve statistics via --statistics for views and other non-table structures found in pg_class. ( Leonardo)

DBD::Pg changed the array output in version 2.0 and later. Versions 1.49 and earlier still need to be parsed as it sends the PostgreSQL data string. Deal with this discrepency quietly. Reported and tested by Christopher Browne. ( Rod)

If --tables is specified then do not output the list of functions. ( Rod)

Enable a password to be provided via a prompt. ( Toshio)

Improve support for UTF8 based strings. ( Dirk)

Correctly set the datadir to share/postgresql_autodoc and create an uninstall target. ( Dirk)

Significant code cleaning and removal of support for PostgreSQL 7.1 and 7.2. 7.3 and later should still function as expected. ( Rod)

Clean up argument handling. ( Jacob)

Fix a set of Dia crashers with the 0.94 release of dia. ( Piebe)

Improve the output of the dot.tmpl file by using HTML structures. Add PK and FK columns. ( Matt)

Create a new GraphViz template named neato.tmpl which is appropriate for graphing tools other than dot, like Neato and Twopi. For best output, try running with -Goverlap=false. ( Tony)

General cleanup of the code and templates for style purposes. ( Rod)

Add table comments to the Dia output. These are truncated to 45 characters. ( Paul)

Fix a bug which resulted in duplicated columns when they were reserved words in postgresql (column named "name"). ( Rod)

Correct a number of bugs. Check constraint formatting in 7.4, functions using numeric data type arguments, and others. ( Rod)

New Dia style with Zigzag line type. This is a good template for databases with a low number of tables. ( Antanas)

Correct GraphViz output when database contains tables named after reserved keywords. ( Rod)

Permission characters were being picked up when in the users name. ( Rod)

Fix output for 7.2 in regards to indexes. ( Rod)

Correct a configure issue with some non-standard versions of Bash. ( Rod)

Use View heading for views rather than calling them tables. ( Andrew)

Add an option to specify the template location during execution. ( Andrew)

Add an option to specify a specific output type, rather than receiving all possible types. ( Andrew)

Display limited function information in HTML and DocBook output formats. ( Andrew, Rod)

Output limited information about non-unique table indexes in DocBook output. Unique indexes are already displayed as constraint output. ( Rod)

Complain if there are no template files in the template directory. ( Rod)

Correct HTML output for specification conformance. ( Rod)

Add note to HTML about PostgreSQL Autodoc. ( Rod)

Write documentation including what variables are used for template creation. ( Rod)

Correct various inter-schema issues with commonly named tables. ( Rod)

Remove sgml.tmpl DocBook output. Replace with xml.tmpl for DocBook output. ( Rod)

Add --statistics support for PostgreSQL 7.4. Requires pgstattuple from contrib to be installed ( Rod)

Correct schema prefix to function names. ( Rod)

Statistics based on PostgreSQL's pgstattuple contrib module ( Rod)

Correct a number of issues with common table names in multiple schemas. (a.j and b.j) ( Rod)

Other bug fixes ( Rod)

Skip plpgsql_call_handler() in PostgreSQL 7.3 and later ( Rod)

Fix column descriptions ( Rod, Arthur )

Use a table connection point for GraphViz output for cleaner formatting. ( Rod)

Ensure that multikey constraints can be associated with a group number (UNIQUE#1, UNIQUE#2, FK#1, FK#2, …) ( Arthur, Rod)

Skip information_schema on 7.4 database ( Rod)

Base the output on templates which are processed by HTML::Template allowing simpler editing of the output for various styles ( Neil, Rod)

Correct the PostgreSQL 7.1 query processes ( Rod)

Add a new --schema argument to enable dumping a single schema ( Rod)

Large cleanups for the various outputs to simplify the code base and remove long standing bugs in DocBook output ( Rod)

Prevent bad Dia output causing crash of Dia ( Rod)

Add View definition to DocBook output ( Rod)

Correct a number of queries for exactness ( Rod)

Simplify Dia output by removing values that are now defaulted and not grouping unless there is more than one schema involved. ( Rod)

HTML stylistic fixes and improved colour scheme. ( Hans)

Have Dia connect to primary / foreign key connection points. ( Ilya)

Add dot (GraphViz) output. ( Ilya)

Improve DocBook output (xref tag names, database comments, array types in tables, @DOCBOOK tag for marked up DocBook comments, output a book not an appendix, ). ( Rod)

Pull out and document functions in DocBook and HTML outputs. ( Rod)

Update for PostgreSQL 7.3 including addition of schemas, new permissions. ( Rod)

Fix -u to work like -U ( Neil)