Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Haberlach <adam@newsnipple.com>
Cc: pgsql-hackers@postgresql.org
Date: 2003-07-24T17:44:44Z
Lists: pgsql-hackers 
Adam Haberlach <adam@newsnipple.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