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

From Per Wigren
Subject Re: Problem with multiple comments
Date
Msg-id CACjysiXgtn+tef-HA94+wFgrBa1dHx5NOpz4QwtEkT6Kko8faw@mail.gmail.com
Whole thread Raw
In response to Re: Problem with multiple comments  (Dave Page <dpage@pgadmin.org>)
Responses Re: Problem with multiple comments  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
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 <dpage@pgadmin.org>
On Thu, Dec 6, 2012 at 9:42 AM, Per Wigren <per.wigren@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

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Problem with multiple comments
Next
From: Dave Page
Date:
Subject: Re: Problem with multiple comments