[#37154] - [4.1] Fix wrong sequence next values in PostgreSQL installation SQL scripts
- Fixed in Code Base
- 27 Feb 2022
- Medium
- Build: 4.1-dev
- # 37154
- Diff
- richard67:4.1-dev-fix-wrong-sequence-next-value-for-postgresql
User tests: Successful: Unsuccessful:
Pull Request for Issue # .
Summary of Changes
This pull request (PR) fixes the next sequence values in PostgreSQL installation SQL scripts which have been forgotten to change when new records for the task scheduler were added with PR #35143 .
Some more wrong values from that PR e.g. for the assets table have already been fixed by someone with some other PR.
Testing Instructions
Code review by someone who knows how sequences work on PostgreSQL, or make a new installation using a PostgreSQL database and then try to insert new records into tables "#__action_logs_extensions" or "#__action_log_config".
Actual result BEFORE applying this Pull Request
Inserting a new record fails with error about duplicate primary key, e.g.:
ERROR: duplicate key value violates unique constraint "j4ux0_action_logs_extensions_pkey" DETAIL: Key (id)=(19) already exists.
Expected result AFTER applying this Pull Request
Inserting a new record works, and the new ID has the right value.
Documentation Changes Required
None.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Postgresql SQL Installation |
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/37154.
I have tested this item
Looks good to me
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/37154.
| Labels |
Added:
?
|
||
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/37154.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/37154.
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2022-02-27 23:25:01 |
| Closed_By | ⇒ | wilsonge | |
| Labels |
Added:
?
|
||
Thanks!
I'm not sure. Obviously in an ideal world yes - but given it affects all existing sites not sure whether it's going to cause more pain that it's worth?
@richard67 This looks good to me.