Re: Relation 'pg_user' does not exist

Matt Beauregard <matt(at)designscape(dot)com(dot)au> writes:
>> Ugh, something's more hosed than I thought, then. What do you get
>> from "select * from pg_class" in template1?

> 65 rows of stuff, including
> pg_user | 0 | 70 | 0 |
> 0 | 0 | 0 | f | f | r |
> 8 | 0 | 0 | 0 | 0 | 0 | f
> | t |
> pg_rules | 0 | 70 | 0 |
> 0 | 0 | 0 | f | f | r |
> 3 | 0 | 0 | 0 | 0 | 0 | f
> | t |
> pg_views | 0 | 70 | 0 |
> 0 | 0 | 0 | f | f | r |
> 3 | 0 | 0 | 0 | 0 | 0 | f
> | t |

The plot thickens ... what did you say the error message was exactly?

Actually, what'd be really useful here is to see where the error is
being reported. Try this:

Window 1: start psql in template1

Window 2: find out PID of backend connected to psql; then, as postgres
user, run "gdb /path/to/postgres/executable" and do this:

attach PID-of-backend
break elog
cont

Window 1: issue failing query (whatever will provoke the error about
pg_user not existing)

Window 2: should get a breakpoint response. Say

bt
quit
y

and send the output from the bt command ...

regards, tom lane