How to get last insert id for FOREIGN TABLE?

Asked Apr 25 '16 at 10:23

Active Apr 27 '16 at 08:29

Viewed 190 times

When inserting row into PosgreSQL FOREIGN TABLE I can not use CURRVAL/LASTVAL because these functions should get value from Postgre sequence, but here row is inserted into MySQL backend and the AUTOINCREMENT is changed.

Is there any way to get LASTINSERTID for that field?
(mysql_fdw postgresql extention officially do not support this)

UPD
I have one suggestion to the topic.
To solve this problem it seems the mysql_fdw extention should implement some UDF so I could SELECT MYSQL_FDW_LASTINSERT_ID which in turn will issue SELECT LAST_INSERT_ID() to MySQL backend for current session

edited Apr 27 '16 at 08:29

asked Apr 25 '16 at 10:23

Eugen Konkov

22,193
17
108
158

1

http://stackoverflow.com/questions/2944297/postgresql-function-for-last-inserted-id – vaso123 Apr 25 '16 at 10:24
SELECT id FROM table_name ORDER BY id DESC LIMIT 1; – Ankit Agrawal Apr 25 '16 at 10:28
@Jordan: this is not safe. What return value will be if concurent transaction will insert and commit new row? – Eugen Konkov Apr 25 '16 at 11:20
@lolka_bolka: I can not use `CURRVAL/LASTVAL because these functions should get value from Postgre sequence, but here row is inserted into MySQL backend`. Have you notice that? – Eugen Konkov Apr 25 '16 at 11:22

How to get last insert id for FOREIGN TABLE?

0 Answers0