Tapio Koskinen created NETBEANS-1140: ----------------------------------------
Summary: Can't insert or delete records on non-default schema Key: NETBEANS-1140 URL: https://issues.apache.org/jira/browse/NETBEANS-1140 Project: NetBeans Issue Type: Bug Affects Versions: 9.0 Reporter: Tapio Koskinen There are some tables in "quartz" schema (PostgreSQL database). Other tables are in "public" schema. In Services-component I can right click those tables, select "View Data..." and table's data is displayed. If I now try to delete a selected record, I get error "Error code 0, SQL state 42P01 Delete command filed: ERROR: relation "qrtz_cron_triggers" does not exist Position: 13" PostgreSQL's log has: 2018-08-15 09:56:03.795 EEST [16908] ERROR: relation "qrtz_cron_triggers" does not exist at character 13 2018-08-15 09:56:03.795 EEST [16908] STATEMENT: DELETE FROM "qrtz_cron_triggers" WHERE "sched_name" = $1 AND "trigger_name" = $2 AND "trigger_group" = $3 2018-08-15 09:56:03.795 EEST [16908] LOG: execute S_1: ROLLBACK So it seems that the schema name is not included in the query when issuing delete statements. Using "Insert Record(s)" functionality fails with the same "relation does not exist" error. Records can be removed manually if schema name is included. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists