Re: Function for Exception Logging

2018-11-05 Thread Alexey Bashtanov
Even more difficult in PG functions as they have no commit / rollback capability.  I haven't played with stored procedures in in PG11 yet. You can simulate oracle autonomous transaction feature in postgres by connecting to the same db using dblink. As for implicit passing of error paramete

Re: Function for Exception Logging

2018-10-30 Thread Tony Shelver
I'd be interested if there is an answer to this. The big issue with writing to a table is the interaction with rollbacks and commits. Even more difficult in PG functions as they have no commit / rollback capability. I haven't played with stored procedures in in PG11 yet. In Oracle, I wrote log