postgresql - ERROR: current transaction is aborted, commands ignored until end of transaction block --- export data from Aqua studio -


i trying export 1 table aquastudio csv file. table has approximately 4.4 million rows. when trying use export window function in aqua studio, facing following error:

error: error: current transaction aborted, commands ignored until end of transaction block

i not understanding problem is. read few articles regarding error , found happening due error in last postgresql command. did not use sql commands export , dont know how debug this. unable view log files.

you shouldn't exporting millions of rows through jdbc/odbc connection, redshift.

for redshift, please use unload command documented here. you'll have unload file s3 , download there.

for postgres, use copy to documented here.


Comments

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

reflection - How to access the object-members of an object declaration in kotlin -

php - Doctrine Query Builder Error on Join: [Syntax Error] line 0, col 87: Error: Expected Literal, got 'JOIN' -