Error: pq: unknown function: pg_get_triggerdef(): function undefined when using tbls doc

[mohammadv184]

What happened

I encountered an error while using the tbls doc command to generate documentation for my CockroachDB database. The error message reads:‍
pq: unknown function: pg_get_triggerdef(): function undefined

What you expected to happened

The documentation should be generated successfully without any errors.

What stack trace or error message from tbls did you see?

pq: unknown function: pg_get_triggerdef(): function undefined

Anything else we need to know?

Environment

• tbls version: 1.62.0
• Database version: CockroachDB CCL v22.2.0 (x86_64-pc-linux-gnu, built 2022/12/05 16:37:36, go1.19.1)
• OS ( Ubuntu bionic, macOS Calalina, WSL2, etc ): Ubuntu 22.04.1 LTS
• Shell ( bash, zsh, poworshell, etc ): zsh
• Stacktrace or error message from tbls ( If you can, set DEBUG=1):

github.com/k1LoW/tbls/drivers/postgres.(*Postgres).Analyze
	/home/runner/work/tbls/tbls/drivers/postgres/postgres.go:144
github.com/k1LoW/tbls/datasource.Analyze
	/home/runner/work/tbls/tbls/datasource/datasource.go:131
github.com/k1LoW/tbls/cmd.glob..func5
	/home/runner/work/tbls/tbls/cmd/doc.go:72
github.com/spf13/cobra.(*Command).execute
	/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:916
github.com/spf13/cobra.(*Command).ExecuteC
	/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:1044
github.com/spf13/cobra.(*Command).Execute
	/home/runner/go/pkg/mod/github.com/spf13/cobra@v1.6.1/command.go:968
github.com/k1LoW/tbls/cmd.Execute
	/home/runner/work/tbls/tbls/cmd/root.go:191
main.main
	/home/runner/work/tbls/tbls/main.go:34
runtime.main
	/opt/hostedtoolcache/go/1.19.5/x64/src/runtime/proc.go:250
runtime.goexit
	/opt/hostedtoolcache/go/1.19.5/x64/src/runtime/asm_amd64.s:1594

• Config ( .tbls.yml ): without config file

[k1LoW]

@mohammadv184 Thank you for your report.

CockroachDB is not supported.

This is a duplicate of #335