Kostis <pgsql(at)pobox(dot)gr> writes:
> ERROR: Deadlock detected.
> See the lock(l) manual page for a possible cause.
Hard to see how you could be getting that with only one process
accessing the database. What else is going on?
Also, you've been pretty incomplete about your description of the
table schema. I am wondering what the index declarations are,
whether there are any foreign key relationships, rules, triggers,
etc.
regards, tom lane