'Unable to resolve object type 'tstzmultirange' on deployed database

I've just created a PostgreSQL database in Amazon RDS. I've connected to it from DataGrip and now I want to run a migration SQL script.

I get this error when I try:

Unable to resolve object type 'tstzmultirange'

I have googled tstzmultirange and it is a built-in PostgreSQL data type. It might be new to PostgreSQL 14, but my RDS database is running PostgreSQL 14 so why is the script giving that error?

enter image description here enter image description here enter image description here

datagrip


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Terraform update Route53 DOMAIN NameServers

Terraform update Route53 DOMAIN NameServers

Terraform update Route53 DOMAIN NameServers

Amazon AWS S3 to Force Download Mp3 File instead of Stream It

How to enable terraform module only with a specific workspace

AWS RDS Postgres: WAL_LEVEL not set to 'logical' after changing rds.logical_replication = 1

Use terraform to set up a lambda function triggered by a scheduled event source

Use terraform to set up a lambda function triggered by a scheduled event source

Self stopping EC2 once task complete?

AWS - SWF - Asynchronous method

Why my cloudformation template is over 1 MB?

AWS elastic beanstalk - WARN install EACCES: permission denied, access '/tmp/.npm'

Aws step functions - Resume from failed step function activity instead of starting a new execution

Redirect Elastic Beanstalk URL to domain name

node-lambda - TypeError: handler is not a function