BUG | My Awesome Bug

[spirillen]

What is the problem you are experiencing?

I am experiencing a problem where...

Mar 25 20:47:07 pyfunceble-01 python3[16172]: Please take the time to update PyFunceble!
Mar 25 20:47:07 pyfunceble-01 python3[16172]: Your version: 4.3.0a21.dev (Blue Duckling: Tulip)
Mar 25 20:47:07 pyfunceble-01 python3[16172]: Upstream version: 4.3.0a23.dev (Blue Duckling: Tulip) NOT RELEASED SO HOW??
Mar 25 21:04:25 pyfunceble-01 python3[35571]: Please take the time to update PyFunceble!
Mar 25 21:04:25 pyfunceble-01 python3[35571]: Your version: 4.3.0a21.dev (Blue Duckling: Tulip)
Mar 25 21:04:25 pyfunceble-01 python3[35571]: Upstream version: 4.3.0a23.dev (Blue Duckling: Tulip)
Mar 25 21:04:25 pyfunceble-01 python3[35571]: Fatal Error: (psycopg2.errors.InsufficientPrivilege) permission denied for schema public
Mar 25 21:04:25 pyfunceble-01 python3[35571]: LINE 2: CREATE TABLE alembic_version (
Mar 25 21:04:25 pyfunceble-01 python3[35571]:                      ^
Mar 25 21:04:25 pyfunceble-01 python3[35571]: [SQL:
Mar 25 21:04:25 pyfunceble-01 python3[35571]: CREATE TABLE alembic_version (
Mar 25 21:04:25 pyfunceble-01 python3[35571]:         version_num VARCHAR(32) NOT NULL,
Mar 25 21:04:25 pyfunceble-01 python3[35571]:         CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
Mar 25 21:04:25 pyfunceble-01 python3[35571]: )
Mar 25 21:04:25 pyfunceble-01 python3[35571]: ]
Mar 25 21:04:25 pyfunceble-01 python3[35571]: (Background on this error at: https://sqlalche.me/e/20/f405)

How can we reproduce the problem?

To reproduce the problem:

1. come to set PYFUNCEBLE_DB_CHARSET=utf8mb4 and not as standard for pgsql PYFUNCEBLE_DB_CHARSET=utf8

Do you have a screenshot?

Screenshot

What did you expect to happen?

I expected that... pyfunceble

1. checked the DB_charset
2. converted the chartset in existing tables

Is there a workaround?

I found a workaround...

delete tables created with utf8mb4

How did you configure PyFunceble?

.PyFunceble.overwrite.yaml

# Your configuration here

Which Operating System did you use?

Ubuntu 22.04 LTS, Debian 12

Which Python Version did you use?

3.11

Which PyFunceble Version did you use?

4.3.0a21.dev as the build of 4.3.0a23.dev are not yet public...

Additional context

I would like to add... Related to https://github.com/funilrys/PyFunceble/issues/391