> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 12 October 2005 14:41
> To: Dave Page
> Cc: pgAdmin Hackers
> Subject: Re: Instrumentation detection bug??
>
> Dave Page wrote:
> > Hi Andreas
> >
> > Just got the following connecting to a 7.4 server with beta 2:
> >
> > ERROR: column reference "proname" is ambiguous
>
> A little more detail how this happens? The full query? too
> many pronames
> in the source.
It happens when connecting to the server:
2005-10-12 14:43:16 QUERY : Set query (borg.postgresql.org: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-12 14:43:17 ERROR : ERROR: column reference "proname" is
ambiguous
Sorry, I can't look into this more atm - I've already spent most of the
day on pg stuff (again!). Need a nice couple of days away somewhere
distant....
/D
