Question

Declare cursors

Posted March 13, 2020 108 views
DigitalOcean Managed PostgreSQL Database

I’m trying to declare CURSOR on table with ~9M records

DECLARE "name" NO SCROLL CURSOR WITH HOLD FOR SELECT ....

and it fails with error: terminating connection due to administrator command. No logs, nothing.

DigitalOcean, any suggestions?

0 answers
Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!