Function postgresIsForeignRelUpdatable

contrib/postgres_fdw/postgres_fdw.c:2289–2338

* postgresIsForeignRelUpdatable * Determine whether a foreign table supports INSERT, UPDATE and/or * DELETE. */

 *		DELETE.
 */
static int
postgresIsForeignRelUpdatable(Relation rel)
{
	bool		updatable;
	ForeignTable *table;
	ForeignServer *server;
	ListCell   *lc;

	/*
	 * By default, all postgres_fdw foreign tables are assumed updatable. This
	 * can be overridden by a per-server setting, which in turn can be
	 * overridden by a per-table setting.
	 */
	updatable = true;

	table = GetForeignTable(RelationGetRelid(rel));
	server = GetForeignServer(table->serverid);

	foreach(lc, server->options)
	{
		DefElem    *def = (DefElem *) lfirst(lc);

		if (strcmp(def->defname, "updatable") == 0)
			updatable = defGetBoolean(def);
	}
	foreach(lc, table->options)
	{
		DefElem    *def = (DefElem *) lfirst(lc);

		if (strcmp(def->defname, "updatable") == 0)
			updatable = defGetBoolean(def);
	}

	/*
	 * Currently "updatable" means support for INSERT, UPDATE and DELETE.
	 */
	if (!updatable)
		return 0;

	/*
	 * Cloudberry only supports INSERT, because UPDATE/DELETE SELECT requires
	 * the hidden column gp_segment_id and the other "ModifyTable mixes
	 * distributed and entry-only tables" issue.
	 */
	UserMapping *user = GetUserMapping(rel->rd_rel->relowner, table->serverid);
	if (greenplumCheckIsCloudberry(user))
		return (1 << CMD_INSERT);
	else
		return (1 << CMD_INSERT) | (1 << CMD_UPDATE) | (1 << CMD_DELETE);
}

/*
 * postgresRecheckForeignScan