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
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
> "andyterry" == andyterry writes:
andyterry> Hi,
andyterry> Using a procedure for the first time to run some processing
andyterry> for each row in a table, generating output to a target
andyterry> table. The following works without COMMIT the example below
andyterry> gives:
andyterr
On 1/21/19 4:43 AM, andyterry wrote:
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: Er
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
