Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id AE74019DE833 for ; Wed, 7 Mar 2012 09:53:24 -0400 (AST) Received: from adsltrust.ath.forthnet.gr ([194.219.204.174] helo=smadev.internal.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5HIu-0002CM-Vq for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 13:53:23 +0000 Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.4/8.14.4) with ESMTP id q27Dr6w9051179 for ; Wed, 7 Mar 2012 15:53:06 +0200 (EET) (envelope-from achill@smadev.internal.net) Received: (from achill@localhost) by smadev.internal.net (8.14.4/8.14.4/Submit) id q27Dr6JO051178 for pgsql-admin@postgresql.org; Wed, 7 Mar 2012 15:53:06 +0200 (EET) (envelope-from achill@smadev.internal.net) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: pg_attribute file in PostgreSQL 9.0 Date: Wed, 7 Mar 2012 15:53:05 +0200 User-Agent: KMail/1.13.7 (FreeBSD/8.2-RELEASE-p3; KDE/4.7.3; amd64; ; ) References: In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Message-Id: <201203071553.05895.achill@smadev.internal.net> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/65 X-Sequence-Number: 39253 On =CE=A4=CE=B5=CF=84 07 =CE=9C=CE=B1=CF=81 2012 15:14:33 Lukasz Brodziak w= rote: > Hello, >=20 > I have a question regarding pg_attribute. In which file it is stored > because the relfilenode for it shows 0 and file 1249 isn't present in > the folder. in my system: dynacom=3D# SELECT pg_relation_filepath('public.vessels'::regclass); pg_relation_filepath=20 =2D--------------------- base/539545/63242177 (1 row) for system catalog tables you will have this relfilenode =3D 0 =2D-=20 Achilleas Mantzios IT DEPT