---
name: "SPI_freeplan"
section: "3"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/SPI_freeplan"
---

# SPI\_freeplan(3)

free a previously saved prepared statement

## NAME

SPI\_freeplan - free a previously saved prepared statement

## SYNOPSIS

```
int SPI_freeplan(SPIPlanPtr plan)
```

## DESCRIPTION

**SPI\_freeplan** releases a prepared statement previously returned by **SPI\_prepare** or saved by **SPI\_keepplan** or **SPI\_saveplan**.

## ARGUMENTS

SPIPlanPtr *plan*

pointer to statement to free

## RETURN VALUE

0 on success; SPI\_ERROR\_ARGUMENT if *plan* is NULL or invalid