SupabaseS
Supabase2mo ago
Marc

A short question regarding temporal_tables extension

Hello supabase discord.

I recently discovered the need to version some rows in my database.

I stumpled upon this article/tutorial:

https://bootstrapped.app/guide/how-to-implement-data-versioning-in-supabase

The article suggests that temporal_tables can be installed with the following query:

CREATE EXTENSION IF NOT EXISTS temporal_tables;


However, when i try to do this in my cloud supabase instance i get the error:

ERROR:  0A000: extension "temporal_tables" is not available
DETAIL:  Could not open extension control file "/usr/lib/postgresql/share/postgresql/extension/temporal_tables.control": No such file or directory.
HINT:  The extension must first be installed on the system where PostgreSQL is running.


This leads me to believe that the article is incorrect, and that the extension is not supported in supabase.

is this assumption correct? or do i need to install the extension in some other way to make it available?
image.png
Explore step-by-step guides on how to use data versioning in Supabase. Improve your database skills and protect important info better. Safeguard critical data with ease and confidence.
Was this page helpful?