tuplesort error from create index (?)

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tuplesort error from create index (?)
Date: 2002-01-02 17:18:29
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452DC1B@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Sarmiento 2002-01-02 17:58:46 tool for synchronizing databases
Previous Message Mark Rae 2002-01-02 17:09:15 Re: Possible bug with shared memory buffers