Are adding view and user to Jira postrgresql db safe?

[Lukasz Sabiniok]

Hello

In order to integrate jira with other system we want to create view in jira postgresql DB:

Something like:

CREATE VIEW view_name AS
SELECT concat_ws('-', p.pkey::text, i.issuenum::text) AS JIRA_ID, i.summary as description
FROM project p, jiraissue i 
WHERE p.id = i.project AND i.issuetype = (SELECT id FROM issuetype WHERE pname = 'something');

Also create DB user with SELECT permissions on this view.

Are actions like this safe or may it cause some failures of Jira and problems with updates?

[Nic Brough -Adaptavist- · Accepted solution]

A view like this will not cause problems, as long as you only ever use it for read, and it doesn't put any significant load on the database.  Upgrades may complain about it or even remove it, but you can put it back afterwards.