Re: Relation 'pg_user' does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matt Beauregard <matt(at)designscape(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Relation 'pg_user' does not exist
Date: 2000-11-08 23:45:15
Message-ID: 28024.973727115@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matt Beauregard <matt(at)designscape(dot)com(dot)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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luis Magaa 2000-11-08 23:49:46 Text concat Problem
Previous Message Ferruccio Zamuner 2000-11-08 23:43:14 Re: permissions on databases vs. permissions on tables