Re: Dependents show up twice?

Le 12/11/2010 10:18, Seifert, Jan-Peter a écrit :
> Hi,
>
>> -----Ursprüngliche Nachricht-----
>> Von: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
>> Gesendet: Donnerstag, 11. November 2010 21:43
>> An: Seifert, Jan-Peter
>> Cc: PgAdmin Support
>> Betreff: Re: [pgadmin-support] Dependents show up twice?
>>
>> Hi,
>>
>> Le 11/11/2010 17:18, Seifert, Jan-Peter a écrit :
>>> [...]
>>> server version is:
>>> PostgreSQL 8.3.12, compiled by Visual C++ build 1400
>>>
>>> I have dumped the schema via pgAdmin III 1.8.4 + 8.3 server
>> binaries
>>> because pgAdmin 1.12.1 + server 9.0 binaries hangs.
>>>
>>
>> OK, I don't reproduce this on my laptop with your schema. No
>> matter which release I use (1.13 and 1.12). Unfortunately, I
>> don't see which commit could have fixed it.
>>
>> But I'm not sure this is an actual bug. They show up twice
>> because they really are in both databases. Did you check both
>> databases?
>
> Yes I did.
> I wouldn't have noticed it if it weren't just three privileges I granted via sql.
>
> I've attached the dump of the other database as well.
> The dependents in this database shown for user bau seem not to be in the dump and aren't displayed in pgAdminIII.
>
> User definition is:
>
> CREATE ROLE bau LOGIN
> ENCRYPTED PASSWORD 'md5cd06cb85de3b74b5c2bad161df92db7d'
> NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
>

I still don't reproduce this.

> The cluster is at least a year old. How can I make sure it's not a server corruption?
>

I don't know. I don't quite understand what happens to you. Unless
you've found a bug, I don't believe in a corruption.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com