ERROR: index "patient_pkey" is not a btree

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: index "patient_pkey" is not a btree
Date: 2006-09-22 06:48:19
Message-ID: 8626C1B7EB748940BCDD7596134632BE3986A2@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi
i am having postgres version 8.0.0 installed, on my machine

i created a database and the tables and the stored procedures for the same

however i get this error, while trying to execute an insert command, in postgreslog

PL/pgSQL function "insert_patient" line 20 at SQL statement
<2006-09-21 03:35:45 IST%SELECT>ERROR: index "patient_pkey" is not a btree
<2006-09-21 03:35:45 IST%SELECT>CONTEXT: SQL statement "insert into patient(patient_name,org_pat_id,birth_date,patient_key)
values( $1 ,trim( $2 ), $3 ,trim( $4 ))"

please tell what may be going wrong,
this is what i did, i just recreated the database and the tables and then everything worked fine.

thanks,
regards
Surabhi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias.Pitzl 2006-09-22 07:04:50 Re: Backup / export DB
Previous Message Najib Abi Fadel 2006-09-22 06:40:56 Can i switch to the use of persistent connections with my already in use application without worrying ?