| From: | Kazutaka Onishi <onishi(at)heterodb(dot)com> |
|---|---|
| To: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
| Cc: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Kohei KaiGai <kaigai(at)heterodb(dot)com> |
| Subject: | Re: TRUNCATE on foreign table |
| Date: | 2021-02-10 17:27:54 |
| Message-ID: | CAJuF6cPwm13tnfRUAcy2CpncEvrGUOaJPuz4rWVFixL28zTA1g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
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.
Anyway, it's more useful if the user can run queries in one place, right?
Do you have any concerns?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2021-02-10 17:35:29 | Re: Extensibility of the PostgreSQL wire protocol |
| Previous Message | Fabrízio de Royes Mello | 2021-02-10 17:22:42 | Re: Extensibility of the PostgreSQL wire protocol |