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