• Fujii Masao's avatar
    Don't pass "ONLY" options specified in TRUNCATE to foreign data wrapper. · 8e9ea08b
    Fujii Masao authored
    Commit 8ff1c946 allowed TRUNCATE command to truncate foreign tables.
    Previously the information about "ONLY" options specified in TRUNCATE
    command were passed to the foreign data wrapper. Then postgres_fdw
    constructed the TRUNCATE command to issue the remote server and
    included "ONLY" options in it based on the passed information.
    
    On the other hand, "ONLY" options specified in SELECT, UPDATE or DELETE
    have no effect when accessing or modifying the remote table, i.e.,
    are not passed to the foreign data wrapper. So it's inconsistent to
    make only TRUNCATE command pass the "ONLY" options to the foreign data
    wrapper. Therefore this commit changes the TRUNCATE command so that
    it doesn't pass the "ONLY" options to the foreign data wrapper,
    for the consistency with other statements. Also this commit changes
    postgres_fdw so that it always doesn't include "ONLY" options in
    the TRUNCATE command that it constructs.
    
    Author: Fujii Masao
    Reviewed-by: Bharath Rupireddy, Kyotaro Horiguchi, Justin Pryzby, Zhihong Yu
    Discussion: https://postgr.es/m/551ed8c1-f531-818b-664a-2cecdab99cd8@oss.nttdata.com
    8e9ea08b
postgres_fdw.sql 133 KB