The article suggests that temporal_tables can be installed with the following query:
CREATE EXTENSION IF NOT EXISTS temporal_tables;
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 availableDETAIL: 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.
ERROR: 0A000: extension "temporal_tables" is not availableDETAIL: 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?
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.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.