Re: Problem with multiple comments
| От | Per Wigren |
|---|---|
| Тема | Re: Problem with multiple comments |
| Дата | |
| Msg-id | CACjysiXgtn+tef-HA94+wFgrBa1dHx5NOpz4QwtEkT6Kko8faw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with multiple comments (Dave Page <dpage@pgadmin.org>) |
| Ответы |
Re: Problem with multiple comments
|
| Список | 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>
Can you provide a reproducible test case please? You cannot haveOn 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.
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 по дате отправления: