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.
Log in to post a comment.