Re: Relation 'pg_user' does not exist

On Wed, Nov 08, 2000 at 06:45:15PM -0500, Tom Lane wrote:
> Matt Beauregard <matt@designscape.com.au> writes:
> >> Hmm, did you do something silly like delete pg_user?
>
> > No... I have no idea where the table went.  Which database do I need
> > to connect to in order to recreate it?  I tried recreating it in
> > template1 and got a set of interesting errors about also missing
> > pg_views.
>
> 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           |


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633