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
