Re: weird problem
Stephan Szabo <sszabo@megazone23.bigpanda.com>
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>, Gavin Sherry <swm@linuxworld.com.au>, Hackers <pgsql-hackers@postgresql.org>
Date: 2003-07-10T03:24:52Z
Lists: pgsql-hackers
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.