Skip to content
You're viewing documentation for v2026.11.7-beta. It may be out of date.Go to latest
TimescaleDB Enterprise
Esc
↑↓navigate↵open⌘Jpreview

Drop an extension

Runs DROP EXTENSION on the live leader, in the database of the extension, and removes the extension and its stored version from the list of the service. confirm must be the name of the extension. Without cascade, an extension with dependents gets 409 with the dependents. With cascade, the drop also drops them (DROP EXTENSION … CASCADE): their data is lost. A required extension gets 400. When the extension has a preload library, deploy the service to remove it from shared_preload_libraries.

POST/api/v1/database-services/{id}/extensions/{name}/drop
Authorization
tse_sessionAPI key · cookierequired
Path parameters
idstringrequired
namestringrequired

The catalog name of the extension, for example pgvector.

Request body
requiredapplication/json
cascadeboolean

Also drop the objects that depend on the extension (DROP EXTENSION ... CASCADE).

confirmstringrequired

The catalog name of the extension, again.

Responses
200

OK

also_droppedstring[]required

The catalog names of the extensions that CASCADE dropped because they require this one. The console removes them from the list too.

cascadebooleanrequired
databasestringrequired
dependentsExtensionDependent[]required

The objects that CASCADE dropped.

Show properties
Array of ExtensionDependent
estimated_rowsinteger<int64>

The estimated rows of the table (pg_class.reltuples). Not set when PostgreSQL has no estimate.

namestringrequired

The name of the object (pg_identify_object identity). For a cron job: its name and schedule.

tablestring

The table of a column.

typestringrequired

The type of the object (pg_identify_object), for example table column, index, view, function, or cron job.

deploy_neededbooleanrequired

The extension has a library in shared_preload_libraries. The next deploy removes the library. A restart then unloads it.

droppedbooleanrequired

False when the extension did not exist in the database. The console then only removes it from the list.

extensionstringrequired
moreinteger<int64>required
default

Error

codestring

Stable code of the refusal, when the route has codes

detailsstring[]

Additional detail, e.g. per-field validation failures

errorstringrequired

Human-readable error message

Request
curl -X POST 'https://console.example.com/api/v1/database-services/string/extensions/string/drop' \
  -H 'Cookie: tse_session=YOUR_API_KEY' \
  -H 'Accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "cascade": true,
  "confirm": "string"
}'
Response
{
  "also_dropped": [
    "string"
  ],
  "cascade": true,
  "database": "string",
  "dependents": [
    {
      "estimated_rows": 0,
      "name": "string",
      "table": "string",
      "type": "string"
    }
  ],
  "deploy_needed": true,
  "dropped": true,
  "extension": "string",
  "more": 0
}