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

UUID (default type for PostgreSQL) highlited as an error #609

Open
4nd3r5on opened this issue Jan 3, 2024 · 0 comments
Open

UUID (default type for PostgreSQL) highlited as an error #609

4nd3r5on opened this issue Jan 3, 2024 · 0 comments

Comments

@4nd3r5on
Copy link

4nd3r5on commented Jan 3, 2024

I have no separate CoC-SQL configuration and default just copypasted from CoC's readme config to setup CoC intself.
I just installed CoC-SQL with CocInstall coc-sql

My SQL migration with the name 0_initial.up.sql

CREATE TABLE IF NOT EXISTS users (
	id            UUID DEFAULT gen_random_uuid() NOT NULL UNIQUE,
	name          TEXT NOT NULL,
	public_key    BYTEA NOT NULL,
	password_hash BYTEA NOT NULL,
	password_salt BYTEA NOT NULL,
	created_at    TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);

The error I'm getting (highlighted near UUID)

Expected "#", "--", "->", "->>", ".", "/*", "BIGINT", "BIT", "CHAR", "DATE", "DATETIME", "DECIMAL", "DOUBLE", "ENUM", "FLOAT", "INT", "INTEGER", "JSON", "LONGTEXT", "MEDIUMTEXT", "NUMERIC", "SMALLINT", "TEXT", "TIME", "TIMESTAMP", "TINYINT", "TINYTEXT", "VARCHAR", "binary", "blob", "boolean", "longblob", "mediumblob", "tinyblob", "varbinary", or [ \t\n\r] but "U" found. (sql)

Similar thing happens with BYTEA type when I'm removing line with UUID or replacing UUID with TEXT.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant