role pgq_admin cannot bulk_insert_events

[florentx]

I tried to use bulk_insert_events from the pgq library, but it does not work out of the box, even after applying the newgrants_pgq.sql permissions.

Since it is special command, I assume that only pgq_admin should be allowed to use it (or maybe pgq_writer as well). It can serve for writing tests for example, or in some special cases.

I worked around the issue by assigning additional grants to pgq_admin:

\i /usr/share/postgresql/9.3/contrib/newgrants_pgq.sql

GRANT INSERT ON pgq.event_template TO pgq_admin;
ALTER DEFAULT PRIVILEGES IN SCHEMA pgq GRANT USAGE ON SEQUENCES TO pgq_admin;