"Tamsin" <[EMAIL PROTECTED]> writes:
> I'm not sure how the database got in this state - would this happen when I
> drop & recreate a user?
Yes. There's no crosscheck to see if you still have active GRANTs for
the user being deleted. (Which is bad but that's how it is at the moment.)
> Is ther
Hi,
when I pg_dump my database, I get lines like:
GRANT SELECT on "tablename" to "28";
When I restore from the dump file, I get errors:
ERROR: aclparse: non-existent user "28"
The dump file does contain grants for the real users which exist in the
database, and I've checked pg_shadow, and there
