Timeline for PostgreSQL:- How to continue execution even INSERT INTO SELECT FROM fails and how to work with refcursor as out param with other output params
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 17, 2021 at 6:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 31, 2020 at 7:07 | answer | added | xzilla | timeline score: 1 | |
| Oct 14, 2020 at 13:28 | history | edited | Sushant | CC BY-SA 4.0 |
added 980 characters in body
|
| Oct 12, 2020 at 14:02 | comment | added | Sushant | Yes, I am catching the exceptions. I realized I didn't add the Exception clause in question... I have edited it now, hope it helps. | |
| Oct 12, 2020 at 14:01 | history | edited | Sushant | CC BY-SA 4.0 |
added 90 characters in body
|
| Oct 12, 2020 at 13:49 | comment | added | McNets | Maybe this error is returned by the function instead of SELECT INTO. Are you catching exceptions inside? | |
| Oct 12, 2020 at 13:47 | comment | added | Sushant | P0002 - "Query returned no rows" | |
| Oct 12, 2020 at 13:33 | comment | added | McNets | Please add error message that you get. I can't reproduce your question on fiddle. dbfiddle.uk/… | |
| Oct 12, 2020 at 12:59 | history | asked | Sushant | CC BY-SA 4.0 |