Re: cannot find attribute 1 of relation (second occurrence.)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>, "Ray Ontko" <rayo(at)ontko(dot)com>
Subject: Re: cannot find attribute 1 of relation (second occurrence.)
Date: 2002-05-21 15:42:47
Message-ID: 21129.1021995767@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nick Fankhauser" <nickf(at)ontko(dot)com> writes:
> No Problem- we'll do that. Is there a table that contains the mapping from
> the database object names to the actual filenames?

Look at the relfilenode column of pg_class for the individual file
names, and at the OID column of pg_database for the directory names.
Probably would be wise to have notes premade about the filenames of
pg_attribute and all its indexes ...

contrib/oid2name may be useful.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message James Kelty 2002-05-21 16:50:01 Rserv and Boolean...
Previous Message Nick Fankhauser 2002-05-21 15:33:46 Re: cannot find attribute 1 of relation (second occurrence.)