Adam Kavan <akavan@cox.net> writes:
> I looked into pg_locks and they are all waiting to get an exclusive
> lock on the same relation. Is there anyway for me to tell what this
> relation is?
To decipher the OIDs in pg_locks, join against pg_class.oid, or just do
select relname from pg_class where oid = nnnn;
> Does anyone know what it could be and how I can fix this
> problem?
Look for the process that already has a lock on the same relation, and
find out what it's waiting for.
regards, tom lane