pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: mjfshark@gmail.com
Subject: BUG #16923: Timestamptz always returns utc time when resultformat is in binary format.
Date: Thu, 11 Mar 2021 12:54:11 +0000
Message-ID: <16923-02bede34869fc819@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16923
Logged by:          Mark Ford
Email address:      mjfshark@gmail.com
PostgreSQL version: 12.3
Operating system:   Windows 10
Description:        

Tested server version 12.3, client versions 10.13 (32bit and 64bit) and
13.2.(64bit)
Issue:
Using libpq.dll and requesting a result set in binary format.  Timestamptz
results are returned in UTC timezone instead of the current session's
timezone setting.  Note that in text format the timestamptz is returned
properly converted.  Also note that Timetz results are converted correctly
regardless of the result set format (binary or text.)

Expected results:
The documentation seems to state that Timestamptz fields will be returned
converted to the currently set timezone session property and doesn't mention
the above behavior.  This combined with timetz fields being converted
regardless of output format seems inconsistent.

Thank you.



view thread (3+ messages)  latest in thread

Message-ID: <16923-02bede34869fc819@postgresql.org>
Permalink:  ../16923-02bede34869fc819@postgresql.org/
Also on:    postgresql.org/message-id/16923-02bede34869fc819@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, mjfshark@gmail.com
  Subject: Re: BUG #16923: Timestamptz always returns utc time when resultformat is in binary format.
  In-Reply-To: <16923-02bede34869fc819@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox