postgresql_user results in psycopg2.ProgrammingError when specifying privileges

[mattupstate]

The following action:

- name: create a test database user
  action: postgresql_user user=vagrant password=password db=vagrant_ansible_tutorial priv=CONNECT/user:ALL

results in the following error:

fatal: [127.0.0.1] => failed to parse: Traceback (most recent call last):
  File "/tmp/ansible-1346283843.64-175065525346012/postgresql_user", line 520, in <module>
    main()
  File "/tmp/ansible-1346283843.64-175065525346012/postgresql_user", line 270, in main
    changed = grant_privileges(cursor, user, privs) or changed
  File "/tmp/ansible-1346283843.64-175065525346012/postgresql_user", line 174, in grant_privileges
    changed = grant_func(cursor, user, name, privilege)\
  File "/tmp/ansible-1346283843.64-175065525346012/postgresql_user", line 97, in grant_table_privilege
    cursor.execute(query)
psycopg2.ProgrammingError: syntax error at or near "user"
LINE 1: GRANT ALL ON TABLE user TO vagrant

[mpdehaan]

want to try to fix it?

I don't maintain these so if not you may want to ask the list.

[mattupstate]

Nevemermind, I think this is because it conflicts with the user table for postgres

[mattupstate]

For that matter, then, the maintainer should be noted in the module or where their fork is located

[mpdehaan]

We're kind of an autonomous collective. Ask the list.