Tickets :: Comment on [#14878] Sequence reset incompatible with PostgreSQL 10+

Search Results: 46 of 173 [ <<First <Prev Next> Last>> ] [ Return to Search Results ]

* Your Email Address
* Spam protection	Enter the letters below: .__ . .. . ..__ [__)\| \|\|\ \| \|[__) \| \\|/\\|\| \\|\__\|[__)
Comment	> After upgrading the database from PostgreSQL 9.6 to 11 certain > operations fail when trying to reset a sequence. > > Example to reproduce: > Create a new event in Kronolith raises an error (see attached log). > After refreshing the page the event is created successfully. > > Cause: > Method "resetPkSequence" in file > "pear/Horde/Db/Adapter/Postgresql/Schema.php" executes the following > SQL: > SELECT setval(%s, (SELECT COALESCE(MAX(%s) + (SELECT increment_by > FROM %s), (SELECT min_value FROM %s)) FROM %s), false) > > Sequence column "increment_by" is no longer available in PostgreSQL > 10 and above.
Attachment
Watch this ticket