Timeline for Error inserting data into PostGIS/PostgreSQL database through postgres_fdw Foreign Data Wrapper
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2023 at 9:02 | vote | accept | Cao Minh Tu | ||
| Mar 6, 2023 at 15:36 | comment | added | JGH | @CaoMinhTu :-) great that it is working. As per the create function definition, the order of some options doesn't matter, so it is fine to have the SET .. at various places, including at the very end, as long as it is not inside the sql body section of course. (PS: and I use it successfully at the end, i.e.... END;$BODY$ LANGUAGE plpgsql SET search_path = public;) | |
| Mar 6, 2023 at 15:04 | comment | added | Cao Minh Tu | I tried putting "SET search_path = public;" at the end of the function as per your suggestion and the error was still raised. The problem was fixed when I put it at the beginning of the function. Please change your answer accordingly so that I can accept it. Thank you very much for your help! | |
| Feb 27, 2023 at 13:49 | history | answered | JGH | CC BY-SA 4.0 |