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

[Bug] Syntax at or near "UUID" #250

Open
cyraid opened this issue Jun 17, 2024 · 2 comments
Open

[Bug] Syntax at or near "UUID" #250

cyraid opened this issue Jun 17, 2024 · 2 comments

Comments

@cyraid
Copy link

cyraid commented Jun 17, 2024

Background

UUID is supported in my Postgres version, and when an .sql file created using the UUID it does exist and is successful.

Overview

In an SQL file, say test.sql, setting the language mode to Postgres, using the following:

CREATE TABLE IF NOT EXISTS "test" (
  "id" UUID
);

Gives:

syntax at or near "UUID"

Screenshot

image

Suggestions

Perhaps even when implementing the recognition of UUID, an 'ignore' type could be an option? Is the extension using EXPLAIN behind the scenes?

Environment

Name Version
Postgres Version 16.2 [64bit linux]
PostgreSQL Extension Version v1.4.3
Host Environment Windows 11
*VSCode 1.90.1
VSCode Environment WSL Ubuntu 22.04 [64bit]
WSL 2.1.5.0

@vdeclerk
Copy link

vdeclerk commented Jul 3, 2024

The same happens with SERIAL and BIGSERIAL.

@vdeclerk
Copy link

vdeclerk commented Jul 3, 2024

If fact it is happening with the type of the first attribute of a CREATE TABLE statement, no matter which type it is.
I'm using version 1.4.3 of the extension too (with Postgres 15.6 on native Linux host).

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

2 participants