Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot find attribute 1 of relation (second occurrence.) - Mailing list pgsql-admin

From Tom Lane
Subject Re: cannot find attribute 1 of relation (second occurrence.)
Date
Msg-id 21129.1021995767@sss.pgh.pa.us
Whole thread Raw
In response to Re: cannot find attribute 1 of relation (second occurrence.)  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
Tree view 
"Nick Fankhauser" <nickf@ontko.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

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: cannot find attribute 1 of relation (second occurrence.)
Next
From: "Luis Andaluz P,"
Date:
Subject: Re: Informacion