PostgresQL error no schema has been selected to create in

[DenuxPlays]

Description

I created a few tables in my database and let the sea-orm-cli generate Rust types from the tables.
Now I want to implement that the schema gets loaded when the tables do not exist in the database.
But now I get the following error:

Steps to Reproduce

1. set up postgresql docker container
2. create a few tables
3. let the cli generate rust types from them
4. delete all tables from the database
5. now let the orm create them (using: schema.create_table_from_entity(user::Entity))

Expected Behavior

That the database uses the standard schema (default public)

Actual Behavior

Getting an SQLx error.

Reproduces How Often

Yes always.
Even after deleting the data folder etc.

Workarounds

Adding this to the table: #[sea_orm(table_name = "user", schema_name = "public")]
Doesn't fix migrations tho!!!

Reproducible Example

Will do this tomorrow!!!

Versions

Database: PostgresQL version 16.1 (Docker)
OS on Docker: Alpine v3.18
Host Os: Fedora 39 Workstation

[DenuxPlays]

Tried giving the user all usage and create permissions on the schema and defining the schema to use in the database uri but both don't work.

[tyt2y3]

I don't understand the problem, did you put the schema name on the connection string? i.e. https://www.sea-ql.org/SeaORM/docs/install-and-config/connection/#postgres

[DenuxPlays]

Yes I did.
Still the same.
Also checked permissions on the schema...

[DenuxPlays]

Fixed it!

In the ConnectOptions I had set set_schema_search_path to my database name instead of my database schema.
Small typo made a big difference. :/