Hi,
Using a procedure for the first time to run some processing for each row in
a table, generating output to a target table. The following works without
COMMIT the example below gives:
INFO: Error Name:cannot commit while a subtransaction is active
INFO: Error State:2D000
Could someone point me
Thanks Adrian,
It is PostgreSQL 11.
The procedure listed is calling one postgres function which is in turn
calling another postgres function but no additional procedure, just
functions.
It's a bit lengthy to explain what the functions are doing so i'll try
testing with a less complex task i think
Thanks Andrew,
The database is currently chewing through the load (without commits) as i'm
doing a batch of rows at a time.
I'm calling the procedure in pgadmin (4-4.2) as i was testing some bits from
there but i'll also try a psql run
Appreciate the pointers, Andy
--
Sent from: http://www.po
