Re: postgres_fdw vs data formatting GUCs (was Re: [v9.3] writable foreign tables)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Farina <daniel@heroku.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2013-03-20T17:13:30Z
Lists: pgsql-hackers
Daniel Farina <daniel@heroku.com> writes:
> On Wed, Mar 20, 2013 at 7:43 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Um ... you shouldn't need a PG_TRY for that at all.  guc.c will take
>> care of popping the values on transaction abort --- that's really rather
>> the whole point of having that mechanism.

> Hmm, well, merely raising the error doesn't reset the GUCs, so I was
> rather thinking that this was a good idea to compose more neatly in
> the case of nested exception processing, e.g.:

In general, we don't allow processing to resume after an error until
transaction or subtransaction abort cleanup has been done.  It's true
that if you look at the GUC state in a PG_CATCH block, you'll see it
hasn't been reset yet, but that's not very relevant.

			regards, tom lane


Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Fix postgres_fdw's issues with inconsistent interpretation of data values.