Re: ERROR: could not find pathkey item to sort

2022-11-21 Thread Vijaykumar Sampat Jain
fyi. The issue was fixed with this PR. https://github.com/adjust/parquet_fdw/pull/60 Thanks, Vijay On Fri, Oct 28, 2022 at 7:59 PM Vijaykumar Sampat Jain < vijaykumar.sampat.j...@adjust.com> wrote: > On Fri, Oct 28, 2022 at 7:15 PM Tom Lane wrote: > > > > > > I think it's most likely a bug in

Re: ERROR: could not find pathkey item to sort

2022-10-28 Thread Vijaykumar Sampat Jain
On Fri, Oct 28, 2022 at 7:15 PM Tom Lane wrote: > > > I think it's most likely a bug in parquet_fdw. We have tests of similar > cases in postgres_fdw, and they work fine. Thanks Tom. I'll lookup the net to see how similar errors were solved in the past to understand what was being sent to postg

Re: ERROR: could not find pathkey item to sort

2022-10-28 Thread Tom Lane
Vijaykumar Sampat Jain writes: > I came across this error/crash when using partitioning of a table with > foreign tables (parquet_fdw) as partitions. > It might be an issue with parquet_fdw nothing with postgresql, but I am not > able to figure out why it crashes around the sorted option set. I t