From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de> |
Cc: | "pgAdmin Hackers" <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Instrumentation detection bug?? |
Date: | 2005-10-12 13:46:23 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC33AC@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2005-10-12 14:14:25 | SVN Commit by andreas: r4532 - trunk/pgadmin3/src/schema |
Previous Message | Andreas Pflug | 2005-10-12 13:41:01 | Re: Instrumentation detection bug?? |