Skip site navigation (1) Skip section navigation (2)

Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Daniel Farina <daniel(at)heroku(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid
Date: 2011-02-22 11:30:52
Message-ID: AANLkTinwCnZPCXi0DghH7Jw2By+iomSZhSv+ux2-2mTr@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Feb 22, 2011 at 8:48 AM, Daniel Farina <daniel(at)heroku(dot)com> wrote:
>  The modern namespace OID is
> 378382, which is in line with a smooth monotonic increase over time.

Wait, what? namespace OID is the OID of the schema. The OID of an
object doesn't change over the lifetime of the object, it's a unique
identifier. So the only reason this would be increasing like this
would be if you're creating schemas continually over time. What
actually is going on in this database?

-- 
greg

In response to

pgsql-bugs by date

Next:From: NilsonDate: 2011-02-22 13:17:19
Subject: BUG #5897: INSTALACAO
Previous:From: Greg StarkDate: 2011-02-22 11:26:17
Subject: Re: Hung Vacuum in 8.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group