[PostGIS] #5666: Build reproducibility: timestamps in extension upgrade SQL scripts

PostGIS trac at osgeo.org
Tue Feb 13 04:56:59 PST 2024


#5666: Build reproducibility: timestamps in extension upgrade SQL scripts
----------------------------+---------------------
  Reporter:  James Addison  |      Owner:  pramsey
      Type:  defect         |     Status:  new
  Priority:  medium         |  Milestone:
 Component:  postgis        |    Version:  3.4.x
Resolution:                 |   Keywords:
----------------------------+---------------------
Comment (by James Addison):

 Please note: the patch as-written specifies an explicit format-string for
 the output date (`+%Y-%m-%d %H:%M:%S`), copied from the
 `POSTGIS_BUILD_DATE` format string
 ([https://trac.osgeo.org/postgis/browser/git/configure.ac?rev=c19ce56ca8982635026ba605f5b2fdce3622bb4a#L1273
 code ref]).

 The example SQL snippet in my description uses that format too - but in
 practice existing strings will have been formatted according to the build
 system's `date` program (`-- Built on Mon Nov 20 20:03:08 UTC 2023`, for
 example).
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5666#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list