Description of problem:

Jabberd 2.3.0 and newer introduced a regression when using a postgresql backend.

Version-Release number of selected component (if applicable):

jabberd-2.3.1-1

How reproducible:

100%.  Upgrade an existing jabberd-2.2.17 installation (configured to use a postgresql backend) with the 2.3.1-1 rawhide package, and watch it break:

(jabberd log)

Dec 2 13:53:27 stuffed jabberd/sm[16886]: pgsql: sql insert failed: ERROR: value "140116104107814" is out of range for type integer

(Database log)

ERROR: value "140116104107814" is out of range for type integer at character 191
STATEMENT: INSERT INTO "status" ( "collection-owner", "object-sequence", "status", "show", "last-login", "xml", "last-logout" ) VALUES ( 'EMAILCUTOUT', nextval('object-sequence'), 'online', '', '140116104107814', 'NAD', '1' );

Both '140116104107814' and '140116104107539' are completely bogus values. In comparison, the values stored in the database for that user are '1386008295' and '1386010131', respectively.

Upstream bug reported (and a possible fix identified) here:

https://github.com/jabberd2/jabberd2/issues/48