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

Поиск
Список
Период
Сортировка
От Daniel Farina
Тема Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid
Дата
Msg-id AANLkTinN1=uth3zppMeUjetWev6gRKLWSGj8mt4jQyLZ@mail.gmail.com
обсуждение исходный текст
Ответ на 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid  (Daniel Farina <daniel@heroku.com>)
Ответы Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid
Список pgsql-bugs
On Mon, Feb 21, 2011 at 10:43 PM, Daniel Farina <daniel@heroku.com> wrote:
> A medium-length story short, this query returns non-zero:
>
> select count(distinct typnamespace) from pg_type where =A0not exists
> (select 1 from pg_namespace where oid =3D pg_type.typnamespace);
>
> I did a very brief search in all the release notes for 8.3.5 to
> 8.3.14, but have not found precisely what I was looking for (searches
> for namespace, schema, type, and corruption).

It may also be useful information to know that no recent shenanigans
have happened on this server: it's been up continuously for about 500
days. That doesn't mean something interesting did not occur a very
long time ago, and I'm currently asking around for any notes about
interesting things that have occurred on this machine.

--=20
fdr

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Daniel Farina
Дата:
Сообщение: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Hung Vacuum in 8.3