Error when deleting items

[deanfourie1]

Deployment Type

Self-hosted

NetBox Version

v4.0.2

Python Version

3.11

Steps to Reproduce

Attempt to delete a device in the "Devices" section.

Expected Behavior

The device to be deleted.

Observed Behavior

Fails to deleted, screenshot provided.

[deanfourie1]

Can see that tables listed here, however I cant seem to delete the,

netbox=> \dt netbox_topology_views_*
                                  List of relations
 Schema |                            Name                            | Type  | Owner  
--------+------------------------------------------------------------+-------+--------
 public | netbox_topology_views_circuitcoordinate                    | table | netbox
 public | netbox_topology_views_coordinate                           | table | netbox
 public | netbox_topology_views_coordinategroup                      | table | netbox
 public | netbox_topology_views_individualoptions                    | table | netbox
 public | netbox_topology_views_individualoptions_preselected_device | table | netbox
 public | netbox_topology_views_individualoptions_preselected_tag    | table | netbox
 public | netbox_topology_views_powerfeedcoordinate                  | table | netbox
 public | netbox_topology_views_powerpanelcoordinate                 | table | netbox
 public | netbox_topology_views_roleimage                            | table | netbox
(9 rows)

netbox-> DROP TABLE netbox_topology_views_roleimage;
DROP TABLE
ERROR:  syntax error at or near "TABLE"
LINE 2: DROP TABLE netbox_topology_views_roleimage;
             ^
netbox-> 

[jeremystretch]

Your SQL command above is appending to a previous line (note the prompt and LINE 2 prefix). The DROP TABLE command is correct and will work on a new line, assuming it's your intention to delete the table.

[deanfourie1]

Thanks, I managed to get it,

DROP TABLE plugin_name_table_name;

Thanks, all sorted.

[deanfourie1]

DROP TABLE plugin_name_table_name;