I'm trying to create a new patron record, and I get the Postgres error 'duplicate key violates unique constraint "usr_address_pkey"'. The relevant entries from /var/log/messages (with postgres query logging turned on) are at http://paste.lisp.org/display/68371.
Any thoughts? We recently discovered that there wasn't an index for tcn_value in biblio.record_entry, so I can't assume that my database is set up optimally in this case either. Ben
