From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Obscure problem due to high system OID or privileges?
Date: Mon, 03 Jan 2011 11:05:30 -0500
Message-ID: <20082.1294070730@sss.pgh.pa.us> (raw)
In-Reply-To: <20110103141602.204670@gmx.net>
References: <20110103141602.204670@gmx.net>
"Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de> writes:
> During 'start up' the application does a couple of SELECTs on pg_catalog:
> SELECT COUNT(*) FROM pg_attribute JOIN pg_type ON pg_attribute.atttypid=pg_type.oid LEFT OUTER JOIN pg_attrdef ON ( pg_attribute.attnum=pg_attrdef.adnum AND pg_attribute.attrelid=pg_attrdef.adrelid ) WHERE pg_attribute.attrelid = 2147483647 AND pg_attribute.attnum >= 0 AND pg_attribute.attisdropped = 'false'
Is the table it's looking for really exactly OID 2147483647 (ie 2^31-1)?
That seems a bit improbable. I suspect something in your app is choking
on an OID that is in fact larger than that, and it's somehow getting
clamped to INT_MAX.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Jan-Peter.Seifert@gmx.de
Subject: Re: Obscure problem due to high system OID or privileges?
In-Reply-To: <20082.1294070730@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox