alter server for foreign table

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: alter server for foreign table
Date: 2017-09-29 17:05:57
Message-ID: bec98664-1a0b-7fa9-1c7b-e25d7e25dad0@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

According to Postgresql documentation it is not possible to alter server
for foreign table:

https://www.postgresql.org/docs/10/static/sql-alterforeigntable.html

But stackoverflow suggests the following hack directly updating
|pg_foreign_table|:
https://stackoverflow.com/questions/37388756/may-i-alter-server-for-foreign-table

I wonder how safe it is and if it is so simple, why it is not support in
ALTER FOREIGN TABLE statement?

Thanks in advance,

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2017-09-29 17:07:17 Re: SQL/JSON in PostgreSQL
Previous Message Robert Haas 2017-09-29 17:03:18 Re: SendRowDescriptionMessage() is slow for queries with a lot of columns