Adam Haberlach <[EMAIL PROTECTED]> writes: > So, one of the many machines that I support seems to have developed > an incredibly odd and specific corruption that I've never seen before. > > Whenever a query requiring an aggregate is attempted, it spits out: > cannot open pg_aggregate: No such file or directory > and fails.
Why not use 'strace' to see what file the backend is actually trying to open? -Doug ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org