postgresqltemporal-tablesbtree-gist

Getting ERROR: type "period" does not exist, even i have added btree_gist and temporal_tables extensions

I'm getting error even i have added btree_gist and temporal_tables extensions.

postgres=# \dx

      Name       | Version |   Schema   |                  Description                  
-----------------+---------+------------+-----------------------------------------------
 btree_gist      | 1.1     | public     | support for indexing common datatypes in GiST
 plpgsql         | 1.0     | pg_catalog | PL/pgSQL procedural language
 temporal_tables | 1.2.0   | public     | temporal tables

(3 rows)

CREATE TABLE b (p PERIOD);
ERROR:  type "period" does not exist
LINE 1: CREATE TABLE b (p PERIOD);

Version details

postgres=# select version();
                                           version                                           
---------------------------------------------------------------------------------------------
 PostgreSQL 9.5.12 on x86_64-alpine-linux-musl, compiled by gcc (Alpine 5.3.0) 5.3.0, 64-bit
Solution

  • If you are talking about this extension, I am not surprised.

    The extension does not define a data type or domain called period.