Re: Triggers on foreign tables

From: Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>
To: Jim Nasby <jim(at)nasby(dot)net>
Cc: Ronan Dunklau <rdunklau(at)gmail(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Triggers on foreign tables
Date: 2013-10-09 19:31:57
Message-ID: CADyhKSXnoPPgEz51k=n-4Oa3WGo9qAxLO+_XN2YYD5WsSGP2FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> What happens if someone changes the record on the foreign side between when
> we've read it and we do the UPDATE?
>
Concurrency control is job of FDW driver. It has to coordinate access to
the records to be fetched for update / delete.
In fact, postgres_fdw add "FOR UPDATE" to avoid concurrent update
when it issues 1st-stage query to remote server.

Thanks,
--
KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-10-09 19:36:47 Re: pg_system_identifier()
Previous Message Robert Haas 2013-10-09 19:25:42 Re: Patch: FORCE_NULL option for copy COPY in CSV mode