"John Sidney-Woollett" <johnsw(at)wardbrook(dot)com> writes:
> Is it possible to use the dblink and dblink_exec features from inside
> pl/pgsql functions to mimic the behaviour of nested transactions by
> calling another function or executing some SQL via the dblink (into the
> same database)?
I wouldn't call it "nested" transactions: the remote transactions would
be committed, and would stay committed even if you roll back the caller.
regards, tom lane