Problem with 7.3 database viewing tables (ERROR: Column reference "proname" is ambiguous)

From: Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
To: pgadmin-support(at)postgresql(dot)org
Subject: Problem with 7.3 database viewing tables (ERROR: Column reference "proname" is ambiguous)
Date: 2005-10-14 14:10:05
Message-ID: 434FBC3D.4050208@kwest.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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_proc pt 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_class rel
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') AND relnamespace = 2200::oid
ORDER BY relname
2005-10-14 14:58:18 ERROR : ERROR: Column reference "proname" is ambiguous

Thanks

Kieran

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-10-14 14:19:59 Re: ERROR: column reference "proname" is ambiguous
Previous Message Michael Nagel 2005-10-14 14:02:06 ERROR: column reference "proname" is ambiguous