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@lelarge.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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com