can't drop table by postgres_scanner

[wonb168]

What happens?

use pgscan(postgres_scanner) to create table in greeenplum, but can't drop it in duckdb; and if drop it in gp, then create in duckdb again, then only table but no data in it, why?

To Reproduce

first, read excel and create table in greenplum

create table uat.ods.excel_trans_route_sku2 as  
select *
from st_read('/Users/mac/Downloads/sku2024.1.8.xlsx', layer='Sheet1', open_options=ARRAY['HEADERS=FORCE']);

then,drop table:

drop table uat.ods.excel_trans_route_sku2

error: nvalid Error: Failed to execute query "BEGIN TRANSACTION; DROP Table "excel_trans_route_sku2"": ERROR: table "excel_trans_route_sku2" does not exist

then drop in gp, and then create it again,

then only table but no data in it, why?

OS:

mac14

PostgreSQL Version:

pg16

DuckDB Version:

0.9.2

DuckDB Client:

java

Full Name:

wang cz

Affiliation:

Linezone

Have you tried this on the latest main branch?

• [X] I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• [X] I agree