bug: postgres: unexpected number of rows: 1

[afifurrohman-id]

• Db url: postgres://postgres:foo@localhost:5432/postgres?search_path=public&sslmode=disable
• Cmd: entimport -dsn
• Postgres Server: 16.3 (Docker)
• SQL:

CREATE TABLE IF NOT EXISTS foo(
    ID UUID UNIQUE DEFAULT GEN_RANDOM_UUID(),
    name VARCHAR(255) NOT NULL,
    PRIMARY KEY(ID)
);

[agulencina96]

I have the same issue

[antham]

Have a look here ent/ent#3752

[afifurrohman-id]

Have a look here ent/ent#3752

It didn't help, i have latest atlas:

atlas version v0.27.1-a360fd8-canary
and postgres 16.3.x

still raise same error

[antham]

Have you read that ent/ent#3752 (comment) ? The pbm is with PG 16 this query
SELECT setting FROM pg_settings WHERE name IN ('lc_collate', 'lc_ctype', 'server_version_num', 'crdb_version') ORDER BY name DESC; doesn't work anymore.

What I did is downgrade PG in 15.X through docker and I imported my schema.

[afifurrohman-id]

What I did is downgrade PG in 15.X through docker and I imported my schema.

We can't do this right now, because we have different teams that manage postgres and used by another app.

[antham]

We can't do this right now, because we have different teams that manage postgres and used by another app.

In my case I did that for an initial import, so I did that in docker just to run a one shot entimport