apache / apache/arrow-adbc

PostgreSQL Timestamp with time zone range type not supported

Open
#1,550 9 comments 0 reactions 0 assignees View on GitHub
Type: bug
Dominant language
C#
Stars
627
Forks
217
Avg merge
22h 22m
Merged PRs (30d)
64

Description

### What happened?

On arrow table fetch I got error saying that type 3910 ( tstzrange ) is not implemented

### How can we reproduce the bug?

Create a table with timestamp range and try to read it using cursor.fetch_arrow_table()

### Environment/Setup

PostgreSQL driver version 0.9.0
Python 3.9
pyarrow 15.0.0
Windows
pip

Contributor guide

Open the contributing guide

Research direction

Reproduce the failure described for cursor.fetch_arrow_table() using a PostgreSQL table with a timestamp-with-time-zone range. Start by locating the PostgreSQL driver's handling of type 3910 (tstzrange), then run the relevant driver tests or reproduction; done means the range can be fetched into an Arrow table without the not-implemented error.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.