Re: [Gnumed-bugs] Problem with rc7 bootstrap

[Karsten Hilbert]

On Sat, Oct 22, 2011 at 01:20:23PM -0700, Jim Busser wrote:

> Could the function stumble if the output of
> 
>       select gm.concat_table_structure(); 
> 
> does not group the table / column descriptions

They are quite ordered, indeed, namely by the hex
representation of the per-line md5 sum:

        for _row in
                select * from information_schema.columns cols
                        where cols.table_name in (
                                select tabs.table_name from 
information_schema.tables tabs where
                                        -- those which hold clinical data
                                        tabs.table_schema in (''dem'', 
''clin'', ''blobs'', ''cfg'', ''ref'', ''i18n'') and
                                        tabs.table_type = ''BASE TABLE''
                                )
                        order by
                                decode(md5(cols.table_schema || cols.table_name 
|| cols.column_name || cols.data_type), ''hex'')
        loop
                _total := _total
                        || _row.table_schema || ''.''
                        || _row.table_name || ''.''
                        || _row.column_name || ''::''
                        || _row.udt_name || E''\n'';
        end loop;

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346