pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: mjfshark@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16923: Timestamptz always returns utc time when resultformat is in binary format.
Date: Thu, 11 Mar 2021 09:18:19 -0500
Message-ID: <20210311141819.GE11261@momjian.us> (raw)
In-Reply-To: <16923-02bede34869fc819@postgresql.org>
References: <16923-02bede34869fc819@postgresql.org>

On Thu, Mar 11, 2021 at 12:54:11PM +0000, PG Bug reporting form wrote:
> 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.

I think you need to show us the commands you ran, and their output.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee






view thread (3+ messages)  latest in thread

Message-ID: <20210311141819.GE11261@momjian.us>
Permalink:  ../20210311141819.GE11261@momjian.us/
Also on:    postgresql.org/message-id/20210311141819.GE11261@momjian.us

 · 

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: bruce@momjian.us, mjfshark@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16923: Timestamptz always returns utc time when resultformat is in binary format.
  In-Reply-To: <20210311141819.GE11261@momjian.us>

* 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