[ckan-dev] Change Group Name??

Thu Nov 19 12:11:10 UTC 2015

Hi.

I need to change the name of one group.

Following this link:

http://stackoverflow.com/questions/18141185/ckan-how-to-restore-a-previously-deleted-group

It seems group table not exist, but is listed in postgres

for example:
*ckan_default=# select * from group;*
ERROR:  syntax error at or near "group"
LINE 1: select * from group;

*ckan_default=# select * from group_extra;*
  id | group_id | key | value | state | revision_id
----+----------+-----+-------+-------+-------------
(0 rows)

How can I fix this?

Thanks

In postgresql I list all tables:

  Schema |             Name              | Type  |    Owner
--------+-------------------------------+-------+--------------
  public | activity                      | table | ckan_default
  public | activity_detail               | table | ckan_default
  public | authorization_group           | table | ckan_default
  public | authorization_group_role      | table | ckan_default
  public | authorization_group_user      | table | ckan_default
  public | dashboard                     | table | ckan_default
  public | geometry_columns              | table | ckan_default
* public | group                         | table | ckan_default
  public | group_extra                   | table | ckan_default
  public | group_extra_revision          | table | ckan_default
  public | group_revision                | table | ckan_default
  public | group_role                    | table | ckan_default*
  public | member                        | table | ckan_default
  public | member_revision               | table | ckan_default
  public | migrate_version               | table | ckan_default
  public | package                       | table | ckan_default
  public | package_extra                 | table | ckan_default
  public | package_extra_revision        | table | ckan_default
  public | package_relationship          | table | ckan_default
  public | package_relationship_revision | table | ckan_default
  public | member_revision               | table | ckan_default
  public | migrate_version               | table | ckan_default
  public | package                       | table | ckan_default
  public | package_extra                 | table | ckan_default
  public | package_extra_revision        | table | ckan_default
  public | package_relationship          | table | ckan_default
  public | package_relationship_revision | table | ckan_default
  public | package_revision              | table | ckan_default
  public | package_role                  | table | ckan_default
  public | package_tag                   | table | ckan_default
  public | package_tag_revision          | table | ckan_default
  public | rating                        | table | ckan_default
  public | related                       | table | ckan_default
  public | related_dataset               | table | ckan_default
  public | resource                      | table | ckan_default
  public | resource_revision             | table | ckan_default
  public | resource_view                 | table | ckan_default
  public | revision                      | table | ckan_default
  public | role_action                   | table | ckan_default
  public | spatial_ref_sys               | table | ckan_default
  public | system_info                   | table | ckan_default
  public | system_info_revision          | table | ckan_default
  public | system_role                   | table | ckan_default
  public | tag                           | table | ckan_default
  public | task_status                   | table | ckan_default
  public | term_translation              | table | ckan_default
  public | tracking_raw                  | table | ckan_default
  public | tracking_summary              | table | ckan_default
  public | user                          | table | ckan_default
  public | user_following_dataset        | table | ckan_default
  public | user_following_group          | table | ckan_default
  public | user_following_user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20151119/bcb45c18/attachment-0002.html>