SELECT pg_advisory_lock($1) (details: pq: unknown function: pg_advisory_lock()) in command line

[lethienhoang]

Version

1.14.0

What happened?

Steps to Reproduce
Steps to reproduce the behavior:

Run "migrate -path internal/sqlc/migrations -database $(DB_URL) -verbose up"
I ran migrate with the following options and get SELECT pg_advisory_lock($1) (details: pq: unknown function: pg_advisory_lock())
I'm using CoakroachDB online
Expected Behavior
It should be apply new schemas to databases

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

No response

What operating system are you using?

macOS

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[kyleconroy]

Cockroach DB does not support pg_advisory_lock. The error you're seeing is a runtime error, not a sqlc error.

cockroachdb/cockroach#13546