Opened 3 years ago
Closed 3 years ago
#33741 closed Bug (invalid)
Transaction Management inside PROCEDURE
Description (last modified by ) ¶
Hello,
I have a PROCEDURE that uses Transaction Management from postgres (meaning there are COMMITs inside the procedure itself)
It runs fine in postgres, but when trying to invoke it from django either via
with connection.cursor() as c: c.execute(...)
or
cursor.callproc
I get the following error:
django.db.utils.InternalError: invalid transaction termination CONTEXT: PL/pgSQL function xxx() line xx at COMMIT
I think that's because when executing raw queries with execute, they are run inside a transaction?
Is there a way to bypass this?
Thanks.
Change History (1)
comment:1 by , 3 years ago
Description: | modified (diff) |
---|---|
Resolution: | → invalid |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
Please see TicketClosingReasons/UseSupportChannels for places to ask usage questions.