joomla/joomla-cms — pull request #3294 by vdespa (2014-03-13 09:47:45+00:00)
Title: PostgreSQL - Later insertions fail after sample data was installed

#### 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.