Thread: Instrumentation detection bug??

Instrumentation detection bug??

From

"Dave Page"

Date:

12 October 2005, 13:10:01

Hi Andreas

Just got the following connecting to a 7.4 server with beta 2:

ERROR:  column reference "proname" is ambiguous

Regards, Dave

Re: Instrumentation detection bug??

From

Andreas Pflug

Date:

12 October 2005, 13:41:07

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

Re: Instrumentation detection bug??

From

"Dave Page"

Date:

12 October 2005, 13:46:26


> -----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

Re: Instrumentation detection bug??

From

Andreas Pflug

Date:

12 October 2005, 14:15:05

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

Re: Instrumentation detection bug??

From

"Dave Page"

Date:

12 October 2005, 14:15:44


> -----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