Skip to content

[Bug][Framework] the migration process is not successful when using Postgres. #5696

@abeizn

Description

@abeizn

Search before asking

  • I had searched in the issues and found no similar issues.

What happened

The migration process is not successful when using Postgres.

  1. ERROR: cached plan must not change result type (SQLSTATE 0A00)
    img_v2_89fcbde4-a095-4843-adf7-58930bd5d43g
  2. ERROR: could not idertify an ordering operator for type json (SQLSTATE42883)
    img_v2_e54d79f4-3ba2-4182-add3-93b20c96b73g
  3. panic: runtime error: invalid memory address or nil pointer dereference
    img_v2_6131ef96-c132-4665-9e52-f032fbbee17g
  4. ERROR: syntax error at or near (SQLSTATE 42601), that causes the process loop.
    33f7f10d-d6b8-48ca-a7e5-460ca26d89c7

What do you expect to happen

The migration process can be successful on PostgreSQL.

How to reproduce

run devlake migration on postgres

Anything else

No response

Version

v0.18.0-beta1

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

Labels

type/bugThis issue is a bug

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions