Re: SQL not showing in generated report - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: SQL not showing in generated report
Date
Msg-id 1323807765.4359.80.camel@localhost.localdomain
Whole thread Raw
In response to Re: SQL not showing in generated report  (Rick Dicaire <kritek@gmail.com>)
List pgadmin-support
On Tue, 2011-12-13 at 10:31 -0500, Rick Dicaire wrote:
> On Tue, Dec 13, 2011 at 2:22 AM, Guillaume Lelarge
> <guillaume@lelarge.info> 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 usesysid=17875;
>  usename  | usesysid
> ----------+----------
>  rdicaire |    17875
> (1 row)
> 
> ###############################################
> 
> select relname,relowner from pg_class where relowner=17875;
>        relname        | relowner
> ----------------------+----------
>  pg_toast_19341       |    17875
>  pg_toast_19341_index |    17875
>  rick_test            |    17875
> (3 rows)
> 
> ################################################

It should have. My understanding is that, if you're owner of an object,
there is a dependency between the object and the user. Maybe my
understanding is wrong. Or maybe the SQL I gave you is wrong. You should
better look at the source file to make sure I didn't give you a wrong
SQL statement.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Backup messages displayed with wrong encoding
Next
From: Guillaume Lelarge
Date:
Subject: Re: pgadmin - problems with servers treeview