]> granicus.if.org Git - postgresql-autodoc/log
postgresql-autodoc
5 years agoMerge pull request #16 from gmr/master master
Christopher Browne [Fri, 25 Oct 2019 22:12:24 +0000 (18:12 -0400)]
Merge pull request #16 from gmr/master

Fix column_default in Postgres 12

5 years agoFix column_default in Postgres 12
Gavin M. Roy [Fri, 25 Oct 2019 21:11:52 +0000 (17:11 -0400)]
Fix column_default in Postgres 12

5 years agoMerge pull request #14 from Dmole/patch-1
Christopher Browne [Wed, 8 May 2019 20:07:24 +0000 (16:07 -0400)]
Merge pull request #14 from Dmole/patch-1

Update README.org

5 years agoUpdate README.org
Tim [Wed, 8 May 2019 19:26:05 +0000 (15:26 -0400)]
Update README.org

install vs build

5 years agoMerge pull request #13 from bozdoz/master
Christopher Browne [Mon, 7 Jan 2019 15:57:31 +0000 (10:57 -0500)]
Merge pull request #13 from bozdoz/master

Add support to run autodoc from within a Docker container

5 years agoAdd Docker instructions to README
bozdoz [Sat, 5 Jan 2019 23:03:52 +0000 (19:03 -0400)]
Add Docker instructions to README

5 years agodockerfile and env example
Benjamin DeLong [Fri, 4 Jan 2019 21:30:09 +0000 (17:30 -0400)]
dockerfile and env example

6 years agoMerge pull request #11 from rubo77/patch-1
Christopher Browne [Wed, 17 Oct 2018 15:44:26 +0000 (11:44 -0400)]
Merge pull request #11 from rubo77/patch-1

Add classes to html.tmpl

6 years agoAdd classes to html.tmpl
Ruben Barkow [Sat, 13 Oct 2018 15:13:03 +0000 (17:13 +0200)]
Add classes to html.tmpl

6 years agoMerge pull request #12 from rubo77/indentions
Christopher Browne [Mon, 15 Oct 2018 16:40:55 +0000 (12:40 -0400)]
Merge pull request #12 from rubo77/indentions

fix indentions in html template

6 years agofix indentions in html template
rubo77 [Sat, 13 Oct 2018 22:20:11 +0000 (00:20 +0200)]
fix indentions in html template

7 years agoIssue #8 - shift URL pointer to the GitHub repo
cbbrowne [Thu, 23 Nov 2017 22:52:37 +0000 (17:52 -0500)]
Issue #8 - shift URL pointer to the GitHub repo
Rod's web site no longer has any autodoc material, so I'm shifting the home reference to the GitHub repo

7 years agoFix #7: Doc name error HTML::Templates to HTML::Template
Håvard Sørli [Mon, 13 Feb 2017 23:50:41 +0000 (00:50 +0100)]
Fix #7: Doc name error HTML::Templates to HTML::Template

7 years agoImprove the documentation
cbbrowne [Wed, 4 Jan 2017 18:35:18 +0000 (13:35 -0500)]
Improve the documentation

8 years agodocumentation tweaks
cbbrowne [Tue, 1 Nov 2016 18:56:56 +0000 (14:56 -0400)]
documentation tweaks

8 years agoMerge pull request #6 from Tecktron/patch-1
Christopher Browne [Tue, 1 Nov 2016 18:54:37 +0000 (14:54 -0400)]
Merge pull request #6 from Tecktron/patch-1

Adding installation and requirements to README

8 years agoAdding installation and requirements to README
Craig [Tue, 1 Nov 2016 17:42:24 +0000 (13:42 -0400)]
Adding installation and requirements to README

8 years agoMore history
cbbrowne [Tue, 20 Sep 2016 20:50:50 +0000 (16:50 -0400)]
More history

8 years agoImprove docs
cbbrowne [Tue, 20 Sep 2016 20:48:12 +0000 (16:48 -0400)]
Improve docs

8 years agoShift Docs to Org mode
cbbrowne [Tue, 20 Sep 2016 20:38:23 +0000 (16:38 -0400)]
Shift Docs to Org mode

8 years agoMerge pull request #4 from devel0/master
Christopher Browne [Tue, 20 Sep 2016 20:22:08 +0000 (16:22 -0400)]
Merge pull request #4 from devel0/master

added dot_shortfk.tmpl

8 years agomore readable font helvetica on dot_shortfk.tmpl, would helpful to translate this...
Lorenzo Delana [Tue, 20 Sep 2016 20:00:47 +0000 (22:00 +0200)]
more readable font helvetica on dot_shortfk.tmpl, would helpful to translate this to an overridable option from command line

8 years agodot_shortfk.tmpl modified to just an empty string
Lorenzo Delana [Tue, 20 Sep 2016 19:43:15 +0000 (21:43 +0200)]
dot_shortfk.tmpl modified to just an empty string

8 years agoadded dot_shortfk.tmpl to Makefile
Lorenzo Delana [Tue, 20 Sep 2016 19:34:08 +0000 (21:34 +0200)]
added dot_shortfk.tmpl to Makefile

8 years agoadded dot short fk template to create dot diagram without fk fullname to help reduce...
Lorenzo Delana [Tue, 20 Sep 2016 19:31:53 +0000 (21:31 +0200)]
added dot short fk template to create dot diagram without fk fullname to help reduce diagram width

8 years agoMerge pull request #3 from timruffles/patch-1
Christopher Browne [Wed, 20 Apr 2016 15:58:36 +0000 (11:58 -0400)]
Merge pull request #3 from timruffles/patch-1

README for github friendly-ness

8 years agoREADME for github friendly-ness
Tim Ruffles [Mon, 18 Apr 2016 10:10:45 +0000 (11:10 +0100)]
README for github friendly-ness

It's unlikely people will use this fantastic tool without seeing a Readme on finding the repo.

8 years agoMerge pull request #1 from bakoontz/pgpass_support
Christopher Browne [Wed, 6 Apr 2016 16:46:47 +0000 (12:46 -0400)]
Merge pull request #1 from bakoontz/pgpass_support

Added support for reading credentials from .pgpass (using -w switch).

9 years agoAdded support for reading credentials from .pgpass (using -w switch).
Brian Koontz [Tue, 14 Jul 2015 21:26:55 +0000 (15:26 -0600)]
Added support for reading credentials from .pgpass (using -w switch).

11 years agoAdd in a sample function using named parameters; this has been not working properly...
Christopher Browne [Wed, 3 Jul 2013 16:30:26 +0000 (12:30 -0400)]
Add in a sample function using named parameters; this has been not working properly in some recent versions

11 years agoSwitch to .gitignore
Christopher Browne [Wed, 3 Jul 2013 16:29:41 +0000 (12:29 -0400)]
Switch to .gitignore

11 years agoAdd README file
Christopher Browne [Mon, 27 May 2013 19:35:01 +0000 (15:35 -0400)]
Add README file

12 years ago1.41 release notes origin
rbt [Thu, 5 Jan 2012 15:31:41 +0000 (15:31 +0000)]
1.41 release notes

12 years agoMark 1.41 release
rbt [Thu, 5 Jan 2012 15:30:33 +0000 (15:30 +0000)]
Mark 1.41 release

12 years agoUpdate schema for Docbook 4.5. Use <database/> where possible.
rbt [Thu, 5 Jan 2012 15:22:28 +0000 (15:22 +0000)]
Update schema for Docbook 4.5. Use <database/> where possible.

14 years agoApply a fix to the function signatures that was reversing argument names.
rbt [Sun, 24 Jan 2010 20:01:07 +0000 (20:01 +0000)]
Apply a fix to the function signatures that was reversing argument names.

Patch created by Jyrki Muukkonen and submitted via Peter Eisentraut

15 years agoAdd the manpage to the release tarball.
rbt [Tue, 11 Aug 2009 18:50:02 +0000 (18:50 +0000)]
Add the manpage to the release tarball.

15 years agoAdd a manpage for PostgreSQL Autodoc (Tim Retout)
rbt [Fri, 7 Aug 2009 02:48:26 +0000 (02:48 +0000)]
Add a manpage for PostgreSQL Autodoc (Tim Retout)

It always installs at the moment (BSD Port won't like that).

15 years agoCorrect the synopsis (Peter Eisentraut)
rbt [Sat, 13 Jun 2009 11:06:55 +0000 (11:06 +0000)]
Correct the synopsis (Peter Eisentraut)

15 years agoFinally, a 1.40 release changelog.
rbt [Fri, 1 May 2009 02:31:54 +0000 (02:31 +0000)]
Finally, a 1.40 release changelog.

15 years agoSeems tar on FreeBSD has changed behaviour since the last release. Copy files to...
rbt [Fri, 1 May 2009 02:31:10 +0000 (02:31 +0000)]
Seems tar on FreeBSD has changed behaviour since the last release. Copy files to new location and build tarball out of that directory.

15 years agoReally fix the release process.
rbt [Fri, 1 May 2009 02:14:29 +0000 (02:14 +0000)]
Really fix the release process.

15 years agoTag for 1.40
rbt [Fri, 1 May 2009 02:13:59 +0000 (02:13 +0000)]
Tag for 1.40

15 years agoAnother crack at 1.40
rbt [Fri, 1 May 2009 02:11:14 +0000 (02:11 +0000)]
Another crack at 1.40

15 years agomake release was broken.
rbt [Fri, 1 May 2009 02:10:46 +0000 (02:10 +0000)]
make release was broken.

15 years agoRelease notes for 1.40
rbt [Fri, 1 May 2009 02:09:37 +0000 (02:09 +0000)]
Release notes for 1.40

15 years agoDon't need relhasindexes, relhasrules, or relhastriggers since older DBs have been...
rbt [Sun, 26 Apr 2009 17:01:57 +0000 (17:01 +0000)]
Don't need relhasindexes, relhasrules, or relhastriggers since older DBs have been dropped. This also makes up 8.4 compatible without additional changes required.

15 years agoImprove wording for --table help (Jamie Nicholson)
rbt [Fri, 24 Apr 2009 04:43:32 +0000 (04:43 +0000)]
Improve wording for --table help (Jamie Nicholson)

15 years agoAdd -m <regex> to only output structures or functions matching a specific regex ...
rbt [Fri, 24 Apr 2009 04:41:53 +0000 (04:41 +0000)]
Add -m <regex> to only output structures or functions matching a specific regex (Simon Michael)

Tidy code along the way.

15 years agoRemove support for PostgreSQL versions earlier than 8.0.
rbt [Fri, 24 Apr 2009 04:21:40 +0000 (04:21 +0000)]
Remove support for PostgreSQL versions earlier than 8.0.

Do a better job of named function parameters.

15 years agoMinor fixes for named functions for newer DBD::Pg's. A long time ago DBD::Pg changed...
rbt [Fri, 24 Apr 2009 04:04:27 +0000 (04:04 +0000)]
Minor fixes for named functions for newer DBD::Pg's. A long time ago DBD::Pg changed from returning an array string to returning an actual array for PostgreSQL arrays. Autodoc did not take this into account.

15 years agoDramatically simplify installation process (Thanks Simon Bertrang).
rbt [Fri, 24 Apr 2009 03:46:28 +0000 (03:46 +0000)]
Dramatically simplify installation process (Thanks Simon Bertrang).

Complex installation checks have never been required so drop it and replace with simple
make functionality.

Targetting to a different installation prefix is done by setting the PREFIX variable:

make PREFIX=/some/new/home install

15 years agoUse datarootdir instead of datadir
rbt [Fri, 24 Apr 2009 03:39:19 +0000 (03:39 +0000)]
Use datarootdir instead of datadir

16 years ago1.31 actual
rbt [Sun, 16 Mar 2008 23:30:09 +0000 (23:30 +0000)]
1.31 actual

16 years agoClean up formatting.
rbt [Wed, 12 Mar 2008 19:00:56 +0000 (19:00 +0000)]
Clean up formatting.

16 years agoDo not output all functions in the database if a specific table list was requested...
rbt [Wed, 12 Mar 2008 19:00:31 +0000 (19:00 +0000)]
Do not output all functions in the database if a specific table list was requested. Good chance it isn't functions the user is after.

16 years agoKeep foreign key defaults (0) when referencing a table which does not exist in our...
rbt [Wed, 12 Mar 2008 18:55:11 +0000 (18:55 +0000)]
Keep foreign key defaults (0) when referencing a table which does not exist in our output.

16 years agoLeonardo Cezar patches:
rbt [Wed, 12 Mar 2008 18:50:19 +0000 (18:50 +0000)]
Leonardo Cezar patches:

One of them to fix a odd behavior when we had views in schema to
schema to extract some reporter.
Previously we got an error on trying to get statistcs from a view,
since views hasn't stats.

The other one to choose which table(s) we want to collect information
with --table=foo,bar,x ... option.

Although it's functional we still get warning when dealing with table
FKs that weren't selected together; among others gotchas ;-).

Unfortunately I didn't find any mailing lists or forum to treat this
issue neither at pgfoundry nor autodoc's website.
--

FKeys still unfixed.
Statistics portion cleaned up by me.
Virtually no testing of input for comma separated values but oh well.

Will follow with a fix to all the "gotchas"

16 years agoTag for 1.31 release. After additional testing to ensure Foriegn Keys work again...
rbt [Wed, 12 Mar 2008 18:24:12 +0000 (18:24 +0000)]
Tag for 1.31 release. After additional testing to ensure Foriegn Keys work again this is what will go out.

16 years agoNew versions of DBD::Pg like to return an array reference instead of the special...
rbt [Wed, 12 Mar 2008 18:21:52 +0000 (18:21 +0000)]
New versions of DBD::Pg like to return an array reference instead of the special text string that PostgreSQL returns.

This might take care of the issue, although only partially tested (FreeBSD ports doesn't have the newer version yet as it breaks a number of applications).

17 years agoRelease 1.30
rbt [Tue, 2 Jan 2007 14:44:04 +0000 (14:44 +0000)]
Release 1.30

17 years agoToshio Kuratomi wrote a patch to allow a password to be provided via prompt.
rbt [Tue, 2 Jan 2007 13:53:19 +0000 (13:53 +0000)]
Toshio Kuratomi wrote a patch to allow a password to be provided via prompt.

18 years agoAssume the strings are in UTF8 instead of in ASCII. This expands on the number of...
rbt [Tue, 16 May 2006 19:01:27 +0000 (19:01 +0000)]
Assume the strings are in UTF8 instead of in ASCII. This expands on the number of characters that we can work with. While not perfect, it is an improvement.

Submitted by: Dirk Jagdmann

18 years agoThe datadir should be /usr/local/share/postgresql_autodoc by default instead of ...
rbt [Tue, 16 May 2006 18:58:48 +0000 (18:58 +0000)]
The datadir should be /usr/local/share/postgresql_autodoc by default instead of /usr/local/share.

Submitted by: Dirk Jagdmann

18 years agoAdd an uninstall target.
rbt [Tue, 16 May 2006 18:57:24 +0000 (18:57 +0000)]
Add an uninstall target.

Submitted by: Dirk Jagdmann

18 years agoDo not prepare() the statistics query if it is not going to be used.
rbt [Fri, 17 Mar 2006 22:32:30 +0000 (22:32 +0000)]
Do not prepare() the statistics query if it is not going to be used.

Prepare() and finish() on an empty string causes DBD::Pg to complain about the finish().

18 years agoAdd in very simple inheritance documentation. Templates other than HTML need to be...
rbt [Mon, 13 Feb 2006 01:15:55 +0000 (01:15 +0000)]
Add in very simple inheritance documentation. Templates other than HTML need to be updated.

Remove support for PostgreSQL 7.1 and 7.2. Continues to support 7.3 and later.

18 years agoDisplay index information in HTML output.
rbt [Sun, 12 Feb 2006 20:27:41 +0000 (20:27 +0000)]
Display index information in HTML output.

19 years agoChangelog for the 1.25 release.
rbt [Tue, 3 May 2005 02:18:30 +0000 (02:18 +0000)]
Changelog for the 1.25 release.

19 years agoPrevent Dia 0.94 from crashing by rearranging the Dependency attributes.
rbt [Tue, 3 May 2005 02:17:32 +0000 (02:17 +0000)]
Prevent Dia 0.94 from crashing by rearranging the Dependency attributes.

19 years agoEliminate Dia warnings for newer versions of dia (new elements).
rbt [Tue, 3 May 2005 02:07:05 +0000 (02:07 +0000)]
Eliminate Dia warnings for newer versions of dia (new elements).

Luckily, Dia will completely ignore these saved values and calculate it's own instead which is convenient because we really have no idea where to place things.

19 years agoTemplate for the Neato and Twopi tools (part of GraphViz) submitted by Tony Wasson.
rbt [Sun, 1 May 2005 05:32:48 +0000 (05:32 +0000)]
Template for the Neato and Twopi tools (part of GraphViz) submitted by Tony Wasson.

19 years agoFinish() the GetVersion sql statement.
rbt [Sun, 1 May 2005 05:13:38 +0000 (05:13 +0000)]
Finish() the GetVersion sql statement.

Set the FK Group number back to being a number instead of the schema name. Accidentally converted earlier while removing the $group variable.

19 years agoMatt Bosworth has provided an updated dot template with PK, FK information and improv...
rbt [Sun, 1 May 2005 05:07:51 +0000 (05:07 +0000)]
Matt Bosworth has provided an updated dot template with PK, FK information and improved styling.

Rod proceeded to break several things, but eventually got it working again.

19 years agoFix GraphViz foreign key links (they were missing).
rbt [Mon, 18 Apr 2005 23:53:52 +0000 (23:53 +0000)]
Fix GraphViz foreign key links (they were missing).

19 years agoThe latest version of dia crashes when I open a dia file produced with
rbt [Mon, 18 Apr 2005 23:48:27 +0000 (23:48 +0000)]
The latest version of dia crashes when I open a dia file produced with
the zigzag.dia.tmpl template. I replaced the following lines in
zigzag.dia.tmpl

<dia:point val="0.0,0.0"/>

with

<dia:point val="1.0,1.0"/>

and dia no longer crashes.

best whishes,
 Piebe de Vries

19 years agoBump copyright date.
rbt [Sun, 27 Feb 2005 19:39:15 +0000 (19:39 +0000)]
Bump copyright date.

19 years agoDo a little bit of cleaning on this old and crufty code.
rbt [Sun, 27 Feb 2005 19:38:12 +0000 (19:38 +0000)]
Do a little bit of cleaning on this old and crufty code.

19 years agoInclude argument names as provided by Jacob Smullyan.
rbt [Sun, 27 Feb 2005 18:08:06 +0000 (18:08 +0000)]
Include argument names as provided by Jacob Smullyan.

Clean up handling of argument types from a schema not in the current path. This means getting rid of the schema prefix added by format_type so when can add our own when appropriate.

20 years agoPush out 1.24
rbt [Wed, 13 Oct 2004 13:46:34 +0000 (13:46 +0000)]
Push out 1.24

20 years agoStrip out quotes in the comparison area.
rbt [Tue, 12 Oct 2004 13:33:46 +0000 (13:33 +0000)]
Strip out quotes in the comparison area.

20 years agoFrom: Bort, Paul
rbt [Tue, 29 Jun 2004 16:40:40 +0000 (16:40 +0000)]
From:  Bort, Paul
Subject:  RE: Patch for Dia templates for Postgresql_AutoDoc
Date:  Tue, 22 Jun 2004 15:23:24 -0400

I've used the same method of shortening as the constraint you mentioned, but
I made it a new entry (table_comment_dia) in the hash rather than mangle the
existing one. I tried to follow the existing naming conventions and coding
style. I picked a total of 45 characters because that seems to be about the
right size on my screen. In testing I also found a bug in Dia that causes a
crash if a comment is too long, but that seems to be in the 100+ character
range, so I'm not worried about 45.

Here are the patches for postgresql_autodoc.pl, dia.tmpl, and
zigzag.dia.tmpl.

20 years ago1.23 Release
rbt [Thu, 3 Jun 2004 01:46:28 +0000 (01:46 +0000)]
1.23 Release

20 years agoHandle the inability to connect to the database (print real error message).
rbt [Tue, 1 Jun 2004 15:22:56 +0000 (15:22 +0000)]
Handle the inability to connect to the database (print real error message).

Use pg_get_constraintdef() for 7.4 and newer databases. PostgreSQL does the formatting all by itself now.

20 years agoInitial revision
rbt [Wed, 12 May 2004 16:00:32 +0000 (16:00 +0000)]
Initial revision