> Matthew <[EMAIL PROTECTED]> 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?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html