requiring PostgreSQL superuser

[Daniel Golle]

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