Re: Packaging request MobilityDB

From: Bradford Boyle <bradford(dot)d(dot)boyle(at)gmail(dot)com>
To: Esteban Zimanyi <estebanzimanyi(at)gmail(dot)com>
Cc: Cédric Villemain <cedric(dot)villemain(at)abcsql(dot)com>, pgsql-pkg-debian(at)lists(dot)postgresql(dot)org, SCHOEMANS Maxime <Maxime(dot)Schoemans(at)ulb(dot)be>
Subject: Re: Packaging request MobilityDB
Date: 2023-06-08 01:02:15
Message-ID: CAOMoQbTCo1_+0A07qROHqdifiCnev8iAZmbVvJt4omvO7SdG4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

I suspect this may be an actual bug. I tested develop (07fafdf1) on both
macOS and Debian. On macOS, changing the timezone is reflected in the
output but not the datestyle. On Debian, changes to timezone and
datestyle are reflected in the output.

On macOS

```sql
SET timezone TO 'Europe/Berlin';
SET datestyle TO 'German';
SELECT now();
-- now
-- ---------------------------------
-- 08.06.2023 02:45:35.214256 CEST
-- (1 row)

-- SELECT set(ARRAY [timestamptz '2000-01-01', '2000-01-02', '2000-01-03']);
-- set
-- --------------------------------------------------------------------------------
-- {"2000-01-01 00:00:00+01", "2000-01-02 00:00:00+01", "2000-01-03
00:00:00+01"}
-- (1 row)
```

On Debian Bookworm

```sql
SET timezone TO 'Europe/Berlin';
SET datestyle TO 'German';
SELECT now();
-- now
-- ---------------------------------
-- 08.06.2023 02:53:11.748104 CEST
-- (1 row)

SELECT set(ARRAY [timestamptz '2000-01-01', '2000-01-02', '2000-01-03']);
-- set
-- -----------------------------------------------------------------------------------
-- {"01.01.2000 00:00:00 CET", "02.01.2000 00:00:00 CET", "03.01.2000
00:00:00 CET"}
-- (1 row)
```

--Bradford

In response to

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Esteban Zimanyi 2023-06-08 14:54:54 Re: Packaging request MobilityDB
Previous Message Esteban Zimanyi 2023-06-07 16:25:57 Re: Packaging request MobilityDB