Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Haberlach <adam(at)newsnipple(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory
Date: 2003-07-24 17:44:44
Message-ID: 11598.1059068684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> Whenever a query requiring an aggregate is attempted, it spits out:
> cannot open pg_aggregate: No such file or directory
> and fails.

Weird. It would be useful to find out exactly what pathname it's trying
to open. strace'ing the backend might be the easiest way.

> Does anyone know if there could be an issue between the i686 and
> athlon optimizations?

Seems unlikely that it would manifest this way, if so. The error is
coming from a low-level routine that would also be used for opening
any other table ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2003-07-24 17:51:29 v7.3.4 bundled ...
Previous Message Doug McNaught 2003-07-24 17:39:19 Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory