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. // Per 2012/12/6 Dave Page <dp...@pgadmin.org> > On Thu, Dec 6, 2012 at 9:42 AM, Per Wigren <per.wig...@gmail.com> wrote: > > When there are multiple comments on a schema, pgAdmin 1.16 will display > one > > duplicate of the schema for each comment, where the only difference is > the > > last line "COMMENT ON SCHEMA schema_name IS 'something';". The same thing > > happens in the function list, where there are many duplicates only > > differencing in the "COMMENT ON FUNCTION ..." line. > > Can you provide a reproducible test case please? You cannot have > multiple comments on a schema, so I'm not sure what you're trying to > describe. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >
