Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgsql initdb fails on schema specification #8221

Closed
gczuczy opened this issue Oct 10, 2021 · 1 comment
Closed

pgsql initdb fails on schema specification #8221

gczuczy opened this issue Oct 10, 2021 · 1 comment

Comments

@gczuczy
Copy link

gczuczy commented Oct 10, 2021

Hello,

When adding a schema into the installer's prefix option (like "rcwm.") initdb fails:

Creating database schema... ERROR: [7] ERROR:  syntax error at or near "."
LINE 11:     CONSTRAINT rcwm.users_username_key UNIQUE (username, mai...
                            ^ (SQL Query: CREATE TABLE rcwm.users (
    user_id integer DEFAULT nextval('rcwm.users_seq'::text) PRIMARY KEY,
    username varchar(128) DEFAULT '' NOT NULL,
    mail_host varchar(128) DEFAULT '' NOT NULL,
    created timestamp with time zone DEFAULT now() NOT NULL,
    last_login timestamp with time zone DEFAULT NULL,
    failed_login timestamp with time zone DEFAULT NULL,
    failed_login_counter integer DEFAULT NULL,
    "language" varchar(5),
    preferences text DEFAULT ''::text NOT NULL,
    CONSTRAINT rcwm.users_username_key UNIQUE (username, mail_host)
))
[FAILED]
ERROR: [7] ERROR:  syntax error at or near "."
LINE 11:     CONSTRAINT rcwm.users_username_key UNIQUE (username, mai...

```                            ^

The schema name is added to place where it's not supposed to be.
@alecpl
Copy link
Member

alecpl commented Oct 24, 2021

Fixed.

@alecpl alecpl closed this as completed Oct 24, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants