Server postgres_fdw "fetch_size" option cannot be updated

Поиск
Список
Период
Сортировка
От Logan Owen
Тема Server postgres_fdw "fetch_size" option cannot be updated
Дата
Msg-id 1514493194.1816836.1218184760.614638F8@webmail.messagingengine.com
обсуждение исходный текст
Ответы Re: Server postgres_fdw "fetch_size" option cannot be updated  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Hi everyone,

I'm playing around with postgres_fdw (version 1.0), and ran into an issue where I wanted to update the "fetch_size"
optionon the server level:
 

sql> CREATE SERVER test_remote FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'postgres2', dbname 'test', updatable
'false')
[2017-12-28 10:30:13] completed in 35ms
sql> ALTER SERVER test_remote OPTIONS (set fetch_size '50')
[2017-12-28 10:30:26] [42704] ERROR: option "fetch_size" not found

However, I am able to properly set the "fetch_size" when originally defining the server:

sql> CREATE SERVER test_remote2 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'postgres2', dbname 'test', updatable
'false',fetch_size '50')
 
[2017-12-28 10:31:26] completed in 24ms


Both the local and remote servers are running the same version of postgres:

PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Order of columns in GROUP BY is significant to the planner.
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Server postgres_fdw "fetch_size" option cannot be updated