CLOSE

Function

CLOSE frees the resources associated with a cursor.

Precautions

• After a cursor is closed, no subsequent operations are allowed on it.
• Cursors that are no longer used should be closed.
• Each non-held open cursor should be implicitly closed after the transaction that created the cursor is terminated with COMMIT or ROLLBACK.
• A holdable cursor is implicitly closed when the transaction that creates the cursor exits through ROLLBACK.
• If the transaction that creates a cursor is committed, the cursor remains open until an explicit CLOSE operation is performed or the client is disconnected.
• DWS does not have an explicit OPEN cursor statement. A cursor opens when you define it with the CURSOR command. You can see all available cursors by querying the pg_cursors system view.

Syntax

1

CLOSE { cursor_name | ALL };

Parameter Description

Examples

Close a cursor.

1

CLOSE cursor1;

Links

FETCH and MOVE