-
Suggestion
-
Resolution: Fixed
-
None
-
1
-
7
-
Problem Definition
Currently, it is have stated that:
PostgreSQL 7.2 and later require a schema to be specified in the <schema-name/> element. If your PostgreSQL database uses the default 'public' schema, this should be specified in the <schema-name/> element as shown below. Ensure that your database schema name is lower-case, as JIRA cannot work with PostgreSQL databases whose schema names contain upper-case characters.
From the official PSQL documentation, when using a schema other than public, DBA needs to update the search_path to include the new schema.
Suggested Solution
Update the documentation to include this information.
Note
A bug that is affected by this is JRASERVER-64886.
- relates to
-
JRASERVER-64886 Create project fails with 'relation "AO_B9A0F0_APPLIED_TEMPLATE" does not exist' error if a schema other than public is used in PostgreSQL
-
- Closed
-
- mentioned in
-
Page Failed to load
Form Name |
---|
[JRASERVER-65717] Update Connecting Postgres documentation with search_path
Resolution | New: Fixed [ 1 ] | |
Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
Status | Original: In Progress [ 3 ] | New: Waiting for Release [ 12075 ] |
PM Reviewed | New: 16/May/2025 | |
Status | Original: Gathering Interest [ 11772 ] | New: In Progress [ 3 ] |
Assignee | Original: Wazza [ wthompson ] | New: Robert Klimkiewicz [ 94e733e73fd4 ] |
Remote Link | New: This issue links to "Page (Confluence)" [ 1017261 ] |
Support reference count | Original: 2 | New: 7 |
UIS | Original: 0 | New: 1 |
UIS | Original: 1 | New: 0 |
UIS | Original: 0 | New: 1 |
UIS | Original: 1 | New: 0 |