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

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: https://bugs.horde.org/ticket/14878
------------------------------------------------------------------------------
  Ticket           | 14878
  Aktualisiert Von | lst_hoe02 at kwsoft.de
  Zusammenfassung  | Sequence reset incompatible with PostgreSQL 10+
  Warteschlange    | Horde Base
  Version          | 5.2.20
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


lst_hoe02 at kwsoft.de (2019-04-15 09:47) hat geschrieben:

Looks like located in Horde/Db/Adapter/Postgresql/Schema.php

One of our Devs suggested to use this in a similar case which should  
work on all PostgreSQL versions at least since 9

select increment from information_schema.sequences where  
sequence_schema='{schema}' and sequence_name='{sequence}'