On 06.12.2012 18:39, Dave Page wrote:
> On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote:
>> Certainly sounds like a very similar problem. If so, the query is
>> simply buggy - it's just that a pg_upgrade'd environment is *much*
>> more likely to run into the problem than before.
>>
>> I onl
On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote:
> Certainly sounds like a very similar problem. If so, the query is
> simply buggy - it's just that a pg_upgrade'd environment is *much*
> more likely to run into the problem than before.
>
> I only checked the usages of pg_shdescription. The
Certainly sounds like a very similar problem. If so, the query is
simply buggy - it's just that a pg_upgrade'd environment is *much*
more likely to run into the problem than before.
I only checked the usages of pg_shdescription. The same bug might well
exist with almost all uses of pg_description.
ok, then the same issue occurs with functions as well because there are the
same kind of duplicates in the list of functions.
2012/12/6 Dave Page
> On Thu, Dec 6, 2012 at 11:03 AM, Per Wigren wrote:
> > Yes, I have actually run pg_upgrade on it... Where can I find details
> about
> > this bug
On Thu, Dec 6, 2012 at 11:03 AM, Per Wigren wrote:
> Yes, I have actually run pg_upgrade on it... Where can I find details about
> this bug?
The CHANGELOG just says:
2012-11-26 MH 1.16.1 Fix query for database descriptions
So I guess the same issue occurs with schemas. I believe it occurs
be
Yes, I have actually run pg_upgrade on it... Where can I find details
about this bug?
The same thing happens with 1.16.1.
2012/12/6 Dave Page
> On Thu, Dec 6, 2012 at 10:47 AM, Per Wigren wrote:
> > I mailed you the screenshots.
> >
> > I snatched the SQL from pg_log that pgAdmin runs when r
On Thu, Dec 6, 2012 at 10:47 AM, Per Wigren 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
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.
2012/12/6 Dave Page
> On Thu, Dec 6, 2012 at 10:31 AM, Per Wigren wrote:
> > When q
On Thu, Dec 6, 2012 at 10:31 AM, Per Wigren 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
> +--+-
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
+--+--+--
On Thu, Dec 6, 2012 at 9:42 AM, Per Wigren 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
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
differe
12 matches
Mail list logo
