Обсуждение: Instrumentation detection bug??
Hi Andreas Just got the following connecting to a 7.4 server with beta 2: ERROR: column reference "proname" is ambiguous Regards, Dave
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. Regards, Andreas
> -----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
Dave Page wrote: > > > >>-----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. Ok, fixed that in 8.x, missed in 7.x. Fixed in svn. Regards, Andreas
> -----Original Message----- > From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] > Sent: 12 October 2005 15:15 > To: Dave Page > Cc: pgAdmin Hackers > Subject: Re: Instrumentation detection bug?? > > Dave Page wrote: > > > > > > > >>-----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. > > Ok, fixed that in 8.x, missed in 7.x. > Fixed in svn. Ta. /D