ards,
-Tom
--------
Tom Darci
[EMAIL PROTECTED]
On Oct 28, 2008, at 7:44 AM, Tom Lane wrote:
Tom Darci <[EMAIL PROTECTED]> writes:
Our PG server is serving up 50 databases or so (with identical
schemas), and the largest one of those has started giving u
Hi All,
Our PG server is serving up 50 databases or so (with identical
schemas), and the largest one of those has started giving us "out of
memory. failed on request of size n" errors in many places. This is a
9 GB database with 100+ tables, the largest of which have 4 million or
so row
>Did you try DROP OWNED BY? It revokes privileges (as well as
>dropping objects owned by said role).
Thank you. That was exactly the *easy* soluton I'd been missing. I swear
I read the page in the manual for "DROP OWNED" several times, hoping to
see something like "Any privileges granted to the
>>
>> That sounds very promising. I'll take a look there.
>
>I may be wrong about the table name but certainly drop role uses some
>set of system tables to do it's work. :)
THANKS for your help, Stephen. Once I've reassigned ownership
I can then easily find out privilege dependencies using
pg_
Hey All-
It seems like there should be an easily-found answer to this, but if
there is, I can't find it.
I am simply trying to drop a role.
So, before dropping it I need to reassign all its owned objects
(REASSIGN OWNED, very handy) and then revoke all privilges it has had
assigned to it.
Hello All-
I am in the process of replacing the backend for a large MS Access
project with PG.
I really could use a Session ID. I would like to create a view like
this:
CREATE VIEW mysettings
AS
SELECT * FROM mysettingstable
WHERE sessionidcolumn = CURRENTSESSIONID()
It is ess
OK... so I see now that Access seems to be having a field day with
opening and closing sessions, in a way that seems out of my control.
This explains why my temporary table solutions (and then my plperl
global variable solution) were not working.
I will have to go with plan B.
I'd still
