Forum OpenACS Q&A: Re: Another 4.6.2 Bug

Collapse
12: Re: Another 4.6.2 Bug (response to 1)
Posted by Jon Griffin on
To save some work, here is the fix for schema browser: In sb_get_table_description
select
          conname as constraint_name,
          consrc as constraint_source
        from
         pg_constraint r join (select oid from pg_class where relname = lower(:table_name)) c
           on (c.oid = r.conrelid)
        order by constraint_name

The problem is the changed system catalog names, but this should fix your problem. I don't know when I will have time to patch the proc, it needs an if for pg_version.