On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote: > > Hmm... I was thinking the index could be somehow corrupted. However, > > it's strange that all databases have the same problem, since pg_trigger > > is not shared across databases. > > > > Have you tried reindexing pg_trigger? > > Can't - I can't log into any database. > > Maybe it's one of psql's startup queries causing the problem?
Maybe, perhaps try a standalone backend (I think you'll need to give it a -P as well). But it is wierd that it's happening on all databases. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match