> Matthew <matt@ctlno.com> writes:
> > 	FYI now when I try to use psql to connect to the database I get this
> > error:
> > 	bash$ psql cms
> > 	psql: FATAL 1:  cannot find attribute 1 of relation pg_trigger
> 
> So the indexes on pg_attribute are hosed too.  I wonder whether that was
> the original source of the problem, and the rest of this is
> side-effects?
> 
> I am starting to think that you'd best initdb and reload, but there is
> one more thing to try: run REINDEX on the whole database in standalone
> mode.  See the documentation for the procedure; I'm not too clear on it
> since I've never had to do it myself.
> 
> 			regards, tom lane
> 
	What do you mean by the whole database?  I have already executed:

	reindex database cms force
	reindex table cases force
	reindex table cases force
	reindex table hits force
	reindex table history force (and a few more)

	How do I get it do reindex the system tables?  One table at a time?


Fri, 23 Mar 2001 12:51:43 -0600
Matthew <matt@ctlno.com>
RE: 7.0.3 _bt_restscan: my bits moved right off the end of the world! 
Matthew <matt@ctlno.com> writes:
> 	What do you mean by the whole database?  I have already executed:

> 	reindex database cms force

(checks manual...)  That appears to be the right syntax.  If you did
that in a standalone backend with the appropriate command line options
(-O and -P) then I think you've done all you can.  Time for a reload :-(

			regards, tom lane

Fri, 23 Mar 2001 14:00:24 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.0.3 _bt_restscan: my bits moved right off the end of the world!