Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-13 Thread Vjacheslav A.
On Wed, Dec 14, 2011 at 12:24 AM, Guillaume Lelarge wrote: > On Sun, 2011-12-11 at 01:30 +0400, Vjacheslav A. wrote: > > On Sun, Dec 11, 2011 at 12:24 AM, Support Dalibo > wrote: > > > > > On Sat, 2011-12-10 at 23:31 +0400, Vjacheslav A. wrote: > > > > On Sat, Dec 10, 2011 at 10:33 PM, Guillaume

Re: [pgadmin-support] Backup messages displayed with wrong encoding

2011-12-13 Thread Alexander LAW
Hello, I don't think that Win1251 encoding is more right than UTF-8. IMHO, a program should understand what encoding is text in or let me choose the encoding to read the text. If you would consider this behavior as a problem (for the conditions described) you could solve it by providing a comb

[pgadmin-support] Problem with pdAdminIII and postgres 9.1.2 on Solaris 10?

2011-12-13 Thread Petra Systems
Hi: I am running postgres 8,3 and 9.1.2 concurrently on solaris 10 08/11. pgAdminIII handles the 8.3 cluster very well but for the 9.1.2 cluster it will not display the databases. It throws error messages to the effect that it can't find columns such as datconfig. The version of pgAdmin

Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-13 Thread Guillaume Lelarge
On Sun, 2011-12-11 at 01:30 +0400, Vjacheslav A. wrote: > On Sun, Dec 11, 2011 at 12:24 AM, Support Dalibo wrote: > > > On Sat, 2011-12-10 at 23:31 +0400, Vjacheslav A. wrote: > > > On Sat, Dec 10, 2011 at 10:33 PM, Guillaume Lelarge > > > wrote: > > > > > > > On Sat, 2011-12-10 at 15:53 +0400, V

Re: [pgadmin-support] SQL not showing in generated report

2011-12-13 Thread Guillaume Lelarge
On Tue, 2011-12-13 at 10:31 -0500, Rick Dicaire wrote: > On Tue, Dec 13, 2011 at 2:22 AM, Guillaume Lelarge > wrote: > > Did you add the role OID after "WHERE dep.refobjid="? if you didn't, > > yeah, you'll get a syntax error. > > Thanks...tried a few role OIDs for known object ownerships, this c

Re: [pgadmin-support] Backup messages displayed with wrong encoding

2011-12-13 Thread Guillaume Lelarge
On Tue, 2011-12-13 at 08:15 +0400, Alexander LAW wrote: > Hi, > To make it clear I am posting two screenshots. > ss_backup_win1251 shows valid table name (which is "Test" in Russian), > but in ss_backup_utf8 you can see the name with wrong encoding. > > When I said "pgAdmin assumes", I meant that

Re: [pgadmin-support] SQL not showing in generated report

2011-12-13 Thread Rick Dicaire
On Tue, Dec 13, 2011 at 2:22 AM, Guillaume Lelarge wrote: > Did you add the role OID after "WHERE dep.refobjid="? if you didn't, > yeah, you'll get a syntax error. Thanks...tried a few role OIDs for known object ownerships, this code returned 0 rows: select usename,usesysid from pg_user where us