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
