#2021 PostgreSQL grant to group, SQL syntax error

1.190
closed
5
2005-04-01
2005-04-01
lbayuk
No

Get an SQL syntax error when trying to grant rights to
a group with the PostgreSQL module. The generated SQL
looks like this:
grant SELECT on "public"."mytable" to "group testgroup"
The error is: ERROR: user "group testgroup" does not exit.
The quotes around the group name are in the wrong
place. It needs to be:
grant SELECT on "public"."mytable" to group "testgroup"

Discussion

  • Jamie Cameron

    Jamie Cameron - 2005-04-01
    • status: open --> closed
     
  • Jamie Cameron

    Jamie Cameron - 2005-04-01

    Logged In: YES
    user_id=129364

    Thanks for this bug report - the next Webmin release will fix it.

     

Log in to post a comment.