[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Handle-info] problems accessing postgres db



Hello,

have got some problems during homing a NA, I am using Postgres as
Backend:

error.log:
"2007/04/07 11:01:25 CEST" 75 class
net.handle.server.HdlTcpRequestHandler: Exception processing request:
HandleException (INTERNAL_ERROR) Error accessing NA data:
org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht:
character varying = bytea

"FEHLER: Operator existiert nicht:" - "Failure: operator does not
exist:"


Here the handles table structure:
ColumnName	Type Name	Size	Scale	Nullable/AutoIncrement	Type	

handle	varchar	255	0	Not Null	false	12	
idx	int4	10	0	Not Null	false	4	
type	bytea	-1	0	Nullable	false	-2	
data	bytea	-1	0	Nullable	false	-2	
ttl_type	int2	5	0	Nullable	false	5	
ttl	int4	10	0	Nullable	false	4	
timestamp	int4	10	0	Nullable	false	4	
refs	bytea	-1	0	Nullable	false	-2	
admin_read	bool	1	0	Nullable	false	-7	
admin_write	bool	1	0	Nullable	false	-7	
pub_read	bool	1	0	Nullable	false	-7	
pub_write	bool	1	0	Nullable	false	-7	


Any ideas? Thank you very much!

Konstantin


-- 
Konstantin Rekk
VZG (GBV), Göttingen, Berlin
0176 2100 6000
030 29003511
skype: krekk1970 
rekk@gbv.de
http://www.gbv.de


_______________________________________________
Handle-Info mailing list
Handle-Info@cnri.reston.va.us
http://www.handle.net/mailman/listinfo/handle-info