lboka/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0152.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

5.0 KiB
Raw Permalink Blame History

CLOSE

Function

CLOSE frees the resources associated with an open cursor.

Precautions

  • After a cursor is closed, no subsequent operations are allowed on it.
  • A cursor should be closed when it is no longer needed.
  • Every non-holdable open cursor is implicitly closed when a transaction is terminated by COMMIT or ROLLBACK.
  • A holdable cursor is implicitly closed if the transaction that created it aborts via ROLLBACK.
  • If the creating transaction successfully commits, the holdable cursor remains open until an explicit CLOSE is executed, or the client disconnects.
  • GaussDB(DWS) does not have an explicit OPEN cursor statement. A cursor is considered open when it is declared. You can see all available cursors by querying the pg_cursors system view.

Syntax

1
CLOSE { cursor_name | ALL } ;

Parameter Description

  • cursor_name

    Specifies the name of a cursor to be closed.

  • ALL

    Closes all open cursors.

Example

Close a cursor.

1
CLOSE cursor1;

Links

FETCH, MOVE

Parent topic: DDL Syntax