Feeling Lucky
?
[#3294] - PostgreSQL - Later insertions fail after sample data was installed
- Closed
- 28 Apr 2014
- Medium
- Build: staging
- # 3294
- Diff
- vdespa:patch-7
- Success The Travis CI build passed Details
User tests: Successful: Unsuccessful:
Steps to reproduce the issue
Install sample data.
After this inserting a new article will fail. because it will try to insert it with id=1 (sequence was not incremented). PostgreSQL works a bit different from MySQL.
Expected result
No issues inserting new data after sample was installed.
Actual result
Fatal SQL errors because of duplicate keys.
System information (as much as possible)
PostgreSQL 9.3
Additional comments
After insertions, the sequence needs to be updated to the max value of the PK in the table.
| Labels |
Added:
?
?
|
||
infograf768
- | Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-04-28 08:00:30 |
Bakual
-
http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=33466&start=0