requiring PostgreSQL superuser

Hi!

I've been playing with recent GNUnet releases and noticed that GNUnet
now requirs PostgreSQL super user privileges.
This is problematic and GNUnet should be able to run with only a more
limited set of PostgreSQL permissions.

The reason for that new requirement is
LOCK TABLE pg_catalog.pg_namespace;
being done in src/lib/pq/versioning.sql

The stackoverflow link provided in the comment above suggests that
locking internal tables is generally not a good idea, and that
transactions should rather be used instead.
Did you consider using transactions? Or is there a good reason not to?


Cheers


Daniel