Question

我已经创建并使用了“SQL”的校正发言。我很想知道,在不切断数据库链接的情况下,是否有办法删除准备的声明? 实现这一点的最佳途径是重新连接和重新准备?

我正在使用SQL版本8.4的校准。我搜索了9.2份文件,但找不到任何与此相关的东西。

Answer 1

According to the documentation, DEALLOCATE is the only way to delete a prepared statement, emphasis added:

Prepared statements for use with PQexecPrepared can also be created by executing SQL PREPARE statements. Also, although there is no libpq function for deleting a prepared statement, the SQL DEALLOCATE statement can be used for that purpose.

假定他们不会因为这样而暴露C功能,因为这样简单:

  char query[NAMEDATALEN+12];
  snprintf(query, sizeof(query), "DEALLOCATE %s", stmtName);
  return PQexec(conn, query);

Answer 2

正如@Amit提到的那样,有时《后台》投掷“准备声明”

Unfortunately, there is no DEALLOCATE IF EXISTS, but a simple workaround is: DEALLOCATE ALL;.

Answer 3

本届会议可删除一份已准备好的发言:

DEALLOCATE PREPARE <name>;

And, you can delete all the prepared statements in the current session:

DEALLOCATE PREPARE ALL;

页: 1

您可自行选择<条码>。
发言稿在登录后删除。
The doc explains DEALLOCATE statement in detail.

友情链接