pg_duckdb icon indicating copy to clipboard operation
pg_duckdb copied to clipboard

ENUM type support

Open wuputah opened this issue 1 year ago • 3 comments

wuputah avatar Aug 07 '24 15:08 wuputah

Hi, I'm very interested in this task. Could I work on it? Thank you very much! @wuputah @Tishj

Reminiscent avatar Aug 13 '24 01:08 Reminiscent

Thanks for your interest! I defer to @Tishj there on whether that makes sense and what the implementation plan should be. Most likely this should build on top of #56 / #97 where enums are copied from Postgres to the DuckDB catalog.

wuputah avatar Aug 13 '24 04:08 wuputah

@wuputah Thanks for your suggestion. I'll try to implement some types which are compatible now. I have some questions want to ask.

  1. Are there any discuss about how to implement some types which are incompatible? And what is the principle.
  2. Could you elaborate on the relationship between the catalog system implemented in this patch and the support for enum types? How does the catalog system specifically enable or facilitate the implementation of enum type support? Can you provide a concrete example of how the catalog changes in this patch would be utilized when implementing enum type support in pg_duckdb? Thanks!

Reminiscent avatar Aug 17 '24 07:08 Reminiscent