MisterRaindrop commented on PR #1842:
URL: https://github.com/apache/cloudberry/pull/1842#issuecomment-4965255918

   > When a foreign table has been created and I press tab after `drop table`, 
there is no foreign table names in the suggestion. I cannot use `drop table` to 
remove a foreign table.
   > 
   > ```
   > postgres=# CREATE FOREIGN TABLE ft (i int) SERVER lake_test_srv;
   > CREATE FOREIGN TABLE
   > postgres=# drop table 
   > gp_toolkit.          information_schema.  public.              t           
         t2                   
   > postgres=# drop table ft;
   > ERROR:  "ft" is not a table
   > HINT:  Use DROP FOREIGN TABLE to remove a foreign table.
   > postgres=# 
   > ```
   > 
   > Iceberg table name is displayed in the suggestion after `drop table`. I 
can use `drop table` to remove an iceberg table.
   > 
   > ```
   > postgres=# CREATE ICEBERG TABLE lake_test_t1 (a int, b text) CATALOG 
lake_test_cat VOLUME lake_test_vol OPTIONS (fileformat 'parquet');
   > CREATE LAKE TABLE
   > postgres=# drop table 
   > gp_toolkit.          information_schema.  lake_test_t1         public.     
         t                    t2                   
   > postgres=# drop table lake_test_t1;
   > DROP TABLE
   > postgres=# 
   > ```
   > 
   > Is it correct? I expect that iceberg table is something like foreign table 
and should be processed using a similar syntax
   
   It's been updated. Tables are now dropped using the DROP ICEBERG TABLE 
syntax.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to