Re: [Gnumed-devel] limitations working from the PG Autodoc html output

[Karsten Hilbert]

> I have further compared what is at http://hherb.com/gnumed/schema/ 
> against some of the sql source and thought it worth pointing out 
> limitations of the html:
> 
>    * lists foreign key references, but does not show the on update / 
> on delete constraint details (available in the /server/sql files)
Which is unfortunate and might be suggested to the author or
submitted a patch for ?

>    * lists formal "comment on table" entries, but not the in-line 
> commenting from the sql files
Because it has no way at all to get at them since it operates
on the live database not the schema source files.

>    * does not show constraints for UNIQUE when these are multi-field 
> -- for example 'unique (id_patient, description)' for the table 
> clin_health_issue
>    * does not show inheritance, though it can be inferred when fields 
> interpose above a table's primary key field; details to be found in 
> the text of the /server/sql files
All interesting things that might be brought to the attention
of the pg_autodoc author.

Still, IMO, it's a useful tool.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346