[Pkg-postgresql-public] Bug#795729: Bug#795729: libpqtypes: FTBFS under some timezones (eg. GMT+12)

[Christoph Berg]

Control: severity -1 important
Control: forwarded -1 http://www.postgresql.org/message-id/20150830102944.GA6531@msg.df7cb.de

Re: Chris Lamb 2015-08-16 <1439731078.1990204.357461057.748C8E3E at webmail.messagingengine.com>
> libpqtypes fails to build from source on unstable/amd64 under
> some timezones (eg. TZ="/usr/share/zoneinfo/Etc/GMT+12"):
> 
>     %timestamptz - FAILED
[...]
>   Date & Time types: (text 'Postgres, MDY')
[...]
>   SENT:
>   epoch=315532800,isbc=0,yr=1979,mon=11,mday=31,jday=0,yday=0,wday=0,hr=12,min=0,sec=0,usec=0,withtz=1,isdst=0,tzabbr=GMT+12,gmtoff=-43200
>   RECV:
>   epoch=315489600,isbc=0,yr=1979,mon=11,mday=31,jday=2444239,yday=364,wday=1,hr=12,min=0,sec=0,usec=0,withtz=1,isdst=-1,tzabbr=USR/SHARE,gmtoff=0

Hi Chris,

thanks for the report!

(Fwiw, your build log has stdout/stderr garbled here, the FAILED line
should be just before SENT, not 50 lines above.)

Confirmed, this is actually a bug in the PostgreSQL server, though it
only shows up with datestyle=postgres (which is pretty obsolete), and
TZ=UTC+-N (which is rare). It will hopefully get fixed in 9.4.5.

I'm downgrading the ftbfs to important, as it doesn't show up when
using "real" timezones. (I'd rather not put a workaround like TZ=UTC
into debian/rules as it would just paper over the issue, and there's
nothing to fix in libpqtypes itself.)

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20150830/13f4c284/attachment-0001.sig>