> How can I find out what this object is?
This query might help if the object is a table:
SELECT c.relname as table,
a.rolname as owner,
c.relacl as permits
FROM pg_class c
JOIN pg_authid a ON ( a.OID = c.relowner )
WHERE relname NOT LIKE 'pg_%'
AND relname NOT LIKE
stan writes:
> I have deleted, what i thought were all the objects referenced by these
> roles,
> but I still get an error saying there is one object they reference.
> How can I find out what this object is?
The error should tell you, if you're connected to the database where
that object is.
I created some roles that I think are badly named, as my understanding of
them increases.
I have deleted, what i thought were all the objects referenced by these roles,
but I still get an error saying there is one object they reference.
How can I find out what this object is?
--
"They that