tuplesort error from create index (?)

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема tuplesort error from create index (?)
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452DC1B@snt452.corp.bcbsm.com
обсуждение исходный текст
Ответы Re: tuplesort error from create index (?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Howdy:

I am running Postgres 7.1 on Mandrake Linux 8.0,
kernel version 2.4.16.

I am trying to create an index on a table:

[snip]

database=> create index key_i on class (contract, memberid, date)

[/snip]

and I get the following error:

[error]

ERROR:  tuplesort: unexpected end of data

[/error]

Never seen this before; have created an index on this table without
seeing a problem.  That is NOT to say that this has never happened
before: I've just not seen it before.

Does number of records have anything to do it this?  I'd think not, but
I suppose it doesn't hurt to ask.  By the way, I have 4699631 records.

Thanks!

-X

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

Предыдущее
От: Jorge Sarmiento
Дата:
Сообщение: tool for synchronizing databases
Следующее
От: Nate Haggard
Дата:
Сообщение: Re: trigger is holding up the data