Skip to content

bug: postgresql unknown type character varying #9141

@reedlxm

Description

@reedlxm

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

as i want to sync from a postgresql to another postgresql,
take an error seams not support character varying type.

Expected Behavior

i guess this is a bug or something goes wrong. that character varying is a very common type

CloudQuery (redacted) config

kind: source
spec:
  name: postgresql
  path: cloudquery/postgresql
  version: "v1.0.5"
  destinations: ["backup"]
  spec:
    connection_string: "postgres://"
---
kind: destination
spec:
  name: backup
  path: cloudquery/postgresql
  version: "v3.0.0"
  spec:
    connection_string: "postgres://"

Steps To Reproduce

No response

CloudQuery (redacted) logs

Starting migration with tables for: postgresql (v1.0.5) -> [backup ([email protected])],
Error: failed to sync v1 source postgresql: failed to migrate source postgresql (v1.0.5) on destination backup ([email protected]) : failed to call Migrate: rpc error: code = Unknown desc = failed listing postgres tables: got unknown PostgreSQL type "character varying(150)" for column "" of table "" while trying to convert it to CloudQuery internal schema type. Supported PostgreSQL types are ["real" "macaddr[]" "inet" "macaddr" "inet[]" "float" "double precision" "text" "bytea" "uuid[]" "boolean" "bigint" "jsonb" "cidr[]" "bigint[]" "integer" "uuid" "text[]" "cidr" "timestamp"]

CloudQuery version

docker leatest

Additional Context

No response

Pull request (optional)

  • I can submit a pull request

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions