[ https://issues.apache.org/jira/browse/NETBEANS-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tapio Koskinen updated NETBEANS-1140: ------------------------------------- Affects Version/s: 11.1 > 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, 11.1 > Reporter: Tapio Koskinen > Priority: Minor > > 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.14#76016) --------------------------------------------------------------------- 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