Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#2432 Delete group problem: PostgreSQL-8.1.x

1.250
closed
Jamie Cameron
5
2006-02-24
2006-02-24
lbayuk
No

Connected to PostgreSQL-8.1.3, I can delete groups
using the Edit Group function (edit_group.cgi, which
uses save_group.cgi) but not from the group listing
(list_groups.cgi, which uses delete_groups.cgi). Trying
to delete a group from the list results in a PostgreSQL
error message about "cannot delete from a view".

The reason is that while save_group.cgi was changed to
do DROP GROUP when deleting groups with PostgreSQL >=
8.0, delete_groups.cgi was not changed and only uses
DELETE FROM PG_GROUP. Now DROP GROUP works on
PostgreSQL >= 8.0, but DELETE FROM PG_GROUP works only
on PostgreSQL < 8.1 (because pg_group was changed to a
view at 8.1). So delete_groups.cgi needs to work like
save_groups.cgi: Use DROP GROUP for PostgreSQL >= 8.0.

Discussion

  • Jamie Cameron
    Jamie Cameron
    2006-02-24

    • status: open --> closed
     
  • Jamie Cameron
    Jamie Cameron
    2006-02-24

    Logged In: YES
    user_id=129364

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