Thread: Problem with 7.3 database viewing tables (ERROR: Column reference "proname" is ambiguous)
Problem with 7.3 database viewing tables (ERROR: Column reference "proname" is ambiguous)
From
Kieran McCusker
Date:
Hi Trying to view a 7.3.4 database running on SUSE I get a MessageBox with the message :- "ERROR: Column reference "proname" is ambiguous" The database works fine with PgAdmin 1.2.2 Got the following with debug logging enabled:- 2005-10-14 14:58:18 INFO : Displaying properties for Tables Tables 2005-10-14 14:58:18 STATUS : Retrieving Tables details... 2005-10-14 14:58:18 QUERY : Set query (kwest2:5432): SELECT rel.oid, relname, pg_get_userbyid(relowner) AS relowner, relacl, relhasoids, relhassubclass, reltuples, description, conname, conkey, EXISTS(select 1 FROM pg_trigger JOIN pg_procpt ON pt.oid=tgfoid AND proname='logtrigger' JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND proname='slonyversion' WHERE tgrelid=rel.oid) AS isrepl FROM pg_classrel LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid AND des.objsubid=0 LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND c.contype='p'WHERE relkind IN ('r','s','t') ANDrelnamespace = 2200::oidORDER BY relname 2005-10-14 14:58:18 ERROR : ERROR: Column reference "proname" is ambiguous Thanks Kieran