Re: Problem with multiple comments - Mailing list pgadmin-support

On Thu, Dec 6, 2012 at 11:03 AM, Per Wigren <per.wigren@gmail.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@pgadmin.org>
>>
>> On Thu, Dec 6, 2012 at 10:47 AM, Per Wigren <per.wigren@gmail.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@pgadmin.org>
>> >>
>> >> On Thu, Dec 6, 2012 at 10:31 AM, Per Wigren <per.wigren@gmail.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