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

Поиск
Список
Период
Сортировка
От Kieran McCusker
Тема Problem with 7.3 database viewing tables (ERROR: Column reference "proname" is ambiguous)
Дата
Msg-id 434FBC3D.4050208@kwest.info
обсуждение исходный текст
Список 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_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



В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: ERROR: column reference "proname" is ambiguous
Следующее
От: "Paolo Saudin"
Дата:
Сообщение: pgAdmin - pgAgent problems