Re: Significance of numbers in server errors? - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Significance of numbers in server errors?
Date
Msg-id AANLkTinJvmjFQMEZteBLYn522VD0_xUYkJexp1yCb2xt@mail.gmail.com
Whole thread Raw
In response to Significance of numbers in server errors?  (Sebastien Boisvert <sebastienboisvert@yahoo.com>)
List pgsql-general
On 4 March 2011 23:15, Sebastien Boisvert <sebastienboisvert@yahoo.com> wrote:
>  I know the second is the database's directory, the last is the pg_attribute
> table (in this example), but I haven't figured out what the first is.

I think that the first is probably the tablespace:

postgres=# select oid,* from pg_tablespace;
-[ RECORD 1 ]-----------
oid         | 1663
spcname     | pg_default
spcowner    | 10
spclocation |
spcacl      |
spcoptions  |
-[ RECORD 2 ]-----------
oid         | 1664
spcname     | pg_global
spcowner    | 10
spclocation |
spcacl      |
spcoptions  |


--
Regards,
Peter Geoghegan

pgsql-general by date:

Previous
From: Sebastien Boisvert
Date:
Subject: Significance of numbers in server errors?
Next
From: Adrian Klaver
Date:
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)