Re: Problem with multiple comments

ok, then the same issue occurs with functions as well because there are the
same kind of duplicates in the list of functions.

2012/12/6 Dave Page <dpage(at)pgadmin(dot)org>

> On Thu, Dec 6, 2012 at 11:03 AM, Per Wigren <per(dot)wigren(at)gmail(dot)com> wrote:
> > Yes, I have actually run pg_upgrade on it... Where can I find details
> about
> > this bug?
>
> The CHANGELOG just says:
>
> 2012-11-26 MH 1.16.1 Fix query for database descriptions
>
> So I guess the same issue occurs with schemas. I believe it occurs
> because pg_upgrade can cause OIDs to be reused in ways not previously
> seen.
>
> > The same thing happens with 1.16.1.
>
> I'll look into it.
>
> >
> > 2012/12/6 Dave Page <dpage(at)pgadmin(dot)org>
> >>
> >> On Thu, Dec 6, 2012 at 10:47 AM, Per Wigren <per(dot)wigren(at)gmail(dot)com>
> wrote:
> >> > I mailed you the screenshots.
> >> >
> >> > I snatched the SQL from pg_log that pgAdmin runs when refreshing the
> >> > list of
> >> > schemas and that query also returns these duplicate schemas. So do the
> >> > Object List Report html output.
> >>
> >> Hmm, odd. I don't suppose you've run pg_upgrade on this database have
> you?
> >>
> >> Magnus fixed a bug similar to this the other day (possibly this very
> >> one). Can you test 1.16.1 please? I just released it an hour ago.
> >>
> >> > 2012/12/6 Dave Page <dpage(at)pgadmin(dot)org>
> >> >>
> >> >> On Thu, Dec 6, 2012 at 10:31 AM, Per Wigren <per(dot)wigren(at)gmail(dot)com>
> >> >> wrote:
> >> >> > When querying pg_description for the oid of one schema that has
> >> >> > duplicates
> >> >> > in pgAdmin I get this:
> >> >> >
> >> >> > bix_live=# select * from pg_description where objoid = 16458;
> >> >> > objoid | classoid | objsubid |
> >> >> > description
> >> >> >
> >> >> >
> >> >> >
> --------+----------+----------+--------------------------------------------------------------------------------------------------------
> >> >> > 16458 | 2615 | 0 | The main comment
> >> >> > 16458 | 1259 | 1 | some other comment
> >> >> > 16458 | 1259 | 2 | yet another comment
> >> >> > 16458 | 1259 | 3 | a different comment
> >> >> > 16458 | 1259 | 4 | another different comment
> >> >> > (5 rows)
> >> >> >
> >> >> > These are the comments that are displayed for the various
> duplicates
> >> >> > in
> >> >> > pgAdmin. Only the main comment is suppsed to be there, I don't know
> >> >> > where
> >> >> > the others come from. The extra comments are the same for all
> schemas
> >> >> > that
> >> >> > have duplicates.
> >> >>
> >> >> The rows with objsubid set to something other than 0 are almost
> >> >> certainly comments on table columns (the sub ID being the column
> >> >> number). That's perfectly normal. I'm still not clear where you're
> >> >> seeing a problem though - can you show me a screenshot of the affect
> >> >> schema in pgAdmin, including both the properties pane showing the
> >> >> schema OID, and the SQL pane?
> >> >>
> >> >> Thanks.
> >> >>
> >> >>
> >> >> --
> >> >> Dave Page
> >> >> Blog: http://pgsnake.blogspot.com
> >> >> Twitter: @pgsnake
> >> >>
> >> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> >> The Enterprise PostgreSQL Company
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Dave Page
> >> Blog: http://pgsnake.blogspot.com
> >> Twitter: @pgsnake
> >>
> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> The Enterprise PostgreSQL Company
> >
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>