Re: pg_locks needs a facelift

> > well, the old ones are GPL. I've made a few attempts to contact the
> > original author...he's MIA. Since 95% of the implementation is in
the
> > backend, it seems odd to have a GPL interface.
>
> I agree. Wasn't it you that was proposing to rewrite the module from
> scratch to eliminate the GPL restriction?
>
> regards, tom lane

Yep. Actually, the biggest part of this was figuring out what to do
about the pg_locks view. Since that's basically decided, all that
remains is to decide what if anything to do about the
max_locks_per_transaction GUC variable. User locks at the very least
are extra-transactional so this could perhaps be renamed. This could
possibly hinge on how Alvaro's 'spill to disk' scenario plays out.

FWIW, I'm a huge fan of the current behavior which is to drop
transactions when running out of lock-space. In any event, I'll rewrite
the interface and the documentation for user-locking with minimal
changes except to expose more of the locktag structure and remove
references to the deprecated and conceptually confusing oid.

Merlin