OffsetDateTime with PostgreSQL

[SteelAlloy]

Setup

Versions

• Rust: 1.66.0
• Diesel: 2.0.3
• Database: PostgreSQL
• Operating System: Linux

Feature Flags

• diesel: time

Problem Description

I'm not sure if it's a missing implementation or if it's misleading documentation. OffsetDateTime seems to be available only for the mysql backend.

What are you trying to accomplish?

Using OffsetDateTime when serializing / deserializing from Timestamp with the PostgreSQL backend.

When looking at the source code, this implementation is only covered for mysql.

What is the expected output?

What is the actual output?

Are you seeing any additional errors?

Steps to reproduce

Checklist

• I have already looked over the issue tracker and the disussion forum for similar possible closed issues.

• This issue can be reproduced on Rust's stable channel. (Your issue will be
  closed if this is not the case)
• This issue can be reproduced without requiring a third party crate

[weiznich]

I converted this to a feature request, as that's not a bug in diesel but more a missing feature. I would probably accept a PR to add the relevant impls for the postgres backend as well.

[jeff-hiner]

After some discussion in #3973 I'm not sure it is a good idea to implement this as asked. There's still a bit of work to be done lining up the TZ-aware types, and maybe some clarification that could be done in the documentation. For my case @Ten0 pointed out it's possible to replace Timestamp with Timestamptz in the schema.rs on Postgres, which a clever workaround that definitely isn't immediately obvious from docs.