| From: | Gilles Darold <gilles(at)darold(dot)net> |
|---|---|
| To: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | [PATCH][DOC] Fix for PREPARE TRANSACTION doc and postgres_fdw message. |
| Date: | 2019-11-01 16:29:23 |
| Message-ID: | 08600ed3-3084-be70-65ba-279ab19618a5@darold.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
As per the following code, t1 is a remote table through postgres_fdw:
test=# BEGIN;
BEGIN
test=# SELECT * FROM t1;
...
test=# PREPARE TRANSACTION 'gxid1';
ERROR: cannot prepare a transaction that modified remote tables
I have attached a patch to the documentation that adds remote tables to
the list of objects where any operation prevent using a prepared
transaction, currently it is just notified "operations involving
temporary tables or the session's temporary namespace".
The second patch modify the message returned by postgres_fdw as per the
SELECT statement above the message should be more comprehensible with:
ERROR: cannot PREPARE a transaction that has operated on remote tables
like for temporary objects:
ERROR: cannot PREPARE a transaction that has operated on temporary
objects
Best regards,
--
Gilles
--
Gilles Darold
http://www.darold.net/
| Attachment | Content-Type | Size |
|---|---|---|
| fix_prepare_transaction_doc-v1.diff | text/x-patch | 957 bytes |
| fix_message_pg_fdw_v1.diff | text/x-patch | 592 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2019-11-01 16:30:49 | Re: [PATCH] Implement INSERT SET syntax |
| Previous Message | Robert Haas | 2019-11-01 16:22:06 | Re: On disable_cost |