Cannot create index

From: Alex Guryanow <gav(at)nlr(dot)ru>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Cannot create index
Date: 2000-01-18 17:36:54
Message-ID: 7858.000118@nlr.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have the table called actions, that contains the column "date" of
type timestamp. When I try to create the index on this column I
receive error:

pqReadData(): -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

I use Postgres 6.5.3 on RedHat 6.1 (kernel 2.2.13). The command I use
to cretate index is:

create index actions_date on actions using btree (date datetime_ops);

Why this happens?

Alex

Browse pgsql-general by date

  From Date Subject
Next Message Easwaran 2000-01-18 18:50:32 Doubt regd PSQL
Previous Message Joe Foster 2000-01-18 17:12:41 SQL 6.5 using views