ALTER COLUMN TYPE from timestamp to timestamp(3) is only supported experimentally

[aep]

Bug Description

with cockroachdb cockroachdb/cockroach:v23.1.13 as a database, migration CreateTagEntity1617270242566 does not apply

To Reproduce

start new n8n with roach

Expected behavior

probably needs to set session variable for roach

https://www.cockroachlabs.com/docs/stable/alter-table#alter-column-data-types

Operating System

l

n8n Version

n8nio/n8n:1.22.3

Node.js Version

whatever is in that docker

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @aep,

Thanks for the report however we don't support Cockroach DB, We support Postgres and SQLite so this is not something I would expect us to change and at the moment I would not recommend using Cockroach DB with n8n.

If you wanted to create a feature request on the forum to have CockroachDB officially supported in the future though we can look into that.

[aep]

aye, might want to change the docs here then to remove cockroachdb https://docs.n8n.io/hosting/configuration/supported-databases-settings/#other-databases

[Joffcom]

@aep Looking at that page we say...

n8n officially supports SQLite and PostgresDB.

We then mention that adding support for Microsoft SQL, Cockroach and Oracle should be possible, We don't say that we support Cockroach DB.

I will have a chat to the docs team and see if we can make that clearer in the future though.