Wrong Postgres SMALLSERIAL export

Report Bugs
1

When I created a table with column type SMALLSERIAL primary key like:

Table event_types {
  id SMALLSERIAL [PK, increment] // sequence number, not snow flake
  name TEXT
  
  created_at TIMESTAMP [NOT NULL, default: `now()`]
}

Expected: Create table SQL should have something like

 CREATE TABLE...
  "id" SMALLSERIAL PRIMARY KEY,
 ...

Actual:

 CREATE TABLE...
 "id" SERIAL PRIMARY KEY,
2

Hello taynguyen!
Thank you for reporting the bug.

For now, we don’t support SMALLSERIAL for increment.
We will update it for next plan.

So if you want SQL to expect after export like:

  CREATE TABLE "event_types"
  "id" SMALLSERIAL PRIMARY KEY,

 ...

You can try:

  Table event_types {
  id SMALLSERIAL [PK] 
  ...
}

Thanks,
Bao

3

Hi taynguyen,
SMALLSERIAL type is currently supported incrementally. You should try it out. Please let us know if you require any additional assistance.

Thank you very much!