Re: "LockRelease: locktable lookup failed, no lock"

Поиск
Список
Период
Сортировка
От Steve Wolfe
Тема Re: "LockRelease: locktable lookup failed, no lock"
Дата
Msg-id 006201bf839c$00d466c0$85755ad1@iboats.com
обсуждение исходный текст
Ответ на "LockRelease: locktable lookup failed, no lock"  ("Steve Wolfe" <steve@iboats.com>)
Список pgsql-general
  Grr....

  Although I'm no longer getting lock releases on this table, a daily
vaccum analyze still shows:

NOTICE:  Rel reef: Uninitialized page 492 - fixing
NOTICE:  Rel reef: Uninitialized page 498 - fixing
NOTICE:  Rel reef: Uninitialized page 499 - fixing

  The database is a fledgling mail archive, when a message comes in, a
program parses the message for the relevant information, inserts it into
the table, and it's done.  Since it's in very early development, there are
only very occasional queries on it.  Here's the schema that I used to
create the table....

create sequence reef_sequence increment 2;

create table reef(
    reef_index              int4 default nextval('reef_sequence') primary
key,
    subject                 varchar(256),
    author                  varchar(256),
    author_email          varchar(256),
    message               text,
    date                    date,
    time                    time,
    is_reply                int
);

  Now I know that there are problems with that, like "is_reply" should be a
bool, not an int.  This is a very old project that I'm just starting up
again... go easy on me. : )

steve


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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [GENERAL] Performance on WindowsNT
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] psql 7.0.0 beta