From: | Per Wigren <per(dot)wigren(at)gmail(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Problem with multiple comments |
Date: | 2012-12-06 10:31:32 |
Message-ID: | CACjysiXgtn+tef-HA94+wFgrBa1dHx5NOpz4QwtEkT6Kko8faw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)pgadmin(dot)org>
> On Thu, Dec 6, 2012 at 9:42 AM, Per Wigren <per(dot)wigren(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2012-12-06 10:37:17 | Re: Problem with multiple comments |
Previous Message | Dave Page | 2012-12-06 09:45:34 | Re: Problem with multiple comments |