Cannot create index - Mailing list pgsql-general

From Alex Guryanow
Subject Cannot create index
Date
Msg-id 7858.000118@nlr.ru
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: "Joe Foster"
Date:
Subject: SQL 6.5 using views
Next
From: "Easwaran"
Date:
Subject: Doubt regd PSQL