Re: Problem with multiple comments

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.

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
>