Tracker: Bugs

5 pgsql analysis never finishes when there are inherited tbls - ID: 3523687
Last Update: Settings changed ( mlt_msk )

I suspect that support for inheritance is missing for PostgreSQL DB analysis. I'm running SchemaSpy 5.0.0 on Windows XP trying to analyse PostgreSQL 9.1.1 DB. If I exclude scheme that contains inherited tables, I get reasonable resuts.

SchemaSpy simply freezes after saying "Writing/Graphing summary.." .

Mikhail Titov ( mlt_msk ) - 2012-05-04 22:01:13 PDT

5

Open

None

Nobody/Anonymous

None

None

Public


Comments ( 3 )

Date: 2012-05-16 23:52:58 PDT
Sender: mlt_mskAccepting Donations

Also I was affected by # 3065002 and had to rebuild SchemaSpy from SVN as
it didn't want to process 5 billion records table.

Date: 2012-05-08 12:06:24 PDT
Sender: mlt_mskAccepting Donations

SchemaSpy does not freeze and works as expected. However inheritance is not
shown. Perhaps this is a limitation of JDBC metadata API. SchemaSpy though
"shows inheritance" when "Implied relationships" is checked. Quite sad
though there is no true support for inheritance. I wonder if this works for
Oracle and MS SQL as those are other only with table inheritance support.

Date: 2012-05-06 21:59:13 PDT
Sender: mlt_mskAccepting Donations

I just realized (using -loglevel finer) that it is querying row count and
it just gets locked since I have a heavy query running. It is likely this
issue in invalid. I'll report back later.

Attached File

No Files Currently Attached

Changes ( 3 )

Field Old Value Date By
status_id Closed 2012-05-16 23:53:07 PDT mlt_msk
status_id Open 2012-05-08 12:06:24 PDT mlt_msk
close_date - 2012-05-08 12:06:24 PDT mlt_msk