On Wed, Feb 10, 2021 at 10:58 PM Kazutaka Onishi <oni...@heterodb.com> wrote: > > That's because using the foreign server is difficult for the user. > > For example, the user doesn't always have the permission to login to the > forein server. > In some cases, the foreign table has been created by the administrator that > has permission to access the two servers and the user only uses the local > server. > Then the user has to ask the administrator to run TRUNCATE every time.
That might actually be seen as a loophole but ... > > Furthermore,there are some fdw extensions which don't support SQL. mongo_fdw, > redis_fdw, etc... > These extensions have been used to provide SQL interfaces to the users. > It's hard for the user to run TRUNCATE after learning each database. this has some appeal. Thanks for sharing the usecases. -- Best Wishes, Ashutosh Bapat
