Data type "smallserial" in Postgres not highlighted in Visual Studio Code

Question

I am new to postgres, and I am using Visual Studio Code IDE (version 1.62) to write my scripts.

While doing so, I am observing this strange behaviour where VS Code doesn't highlight the data type smallserial (2 bytes).

Here is what I see:

But I know that the script is correct because this query runs successfully. How can I get the proper highlighting here?

Erwin Brandstetter · Accepted Answer · 2021-11-07 16:25:24Z

1

That's probably because smallserial (like serial or bigserial) are not actual data types. See:

In Postgres 10 or later, consider an IDENTITY column instead. See:

Auto increment table column

If serial and bigserial are highlighted, but smallserial is not, then that's inconsistent and should be fixed.

edited Nov 7, 2021 at 16:25

answered Nov 7, 2021 at 14:59

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Indrajeet Patil Over a year ago

Thanks, but then how come VS Code serial and bigserial, but serial or smallserial. All of them are pseudo data types, so why only one is not recognized by VS Code?

Erwin Brandstetter Over a year ago

Thst's a bug then. A missing keyword in their list.

Indrajeet Patil Over a year ago

Okay, thanks! I will create an issue on their GitHub repo then.

Collectives™ on Stack Overflow

Data type "smallserial" in Postgres not highlighted in Visual Studio Code

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related