ERROR: index "patient_pkey" is not a btree

Started by surabhi.ahujaover 19 years ago2 messagesgeneral
Jump to latest
#1surabhi.ahuja
surabhi.ahuja@iiitb.ac.in

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: surabhi.ahuja (#1)
Re: ERROR: index "patient_pkey" is not a btree

"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> writes:

i am having postgres version 8.0.0 installed, on my machine

^^^^^

The 8.0 branch is up to 8.0.8. You have just found one of the reasons
why. Update.

regards, tom lane