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