The autoIncrement feature is causing a syntax error at or near "SERIAL"

Encountering a build error :

Unable to start server due to the following SequelizeDatabaseError: syntax error at or near "SERIAL"

This issue arises only when using the autoIncrement=true parameter for the primary key.

'use strict';

export default function(sequelize, DataTypes) {
  return sequelize.define('Ladder', {
    ladder_id: {
      type: DataTypes.UUID,
      allowNull: false,
      primaryKey: true,
      autoIncrement: true //<------- If commented it works fine
    },
    ladder_name: {
      type: DataTypes.STRING(50),
      allowNull: false,
      unique: true
    },
    ladder_description: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    ladder_open: {
      type: DataTypes.BOOLEAN,
      allowNull: false
    },
    ladder_hidden: {
      type: DataTypes.BOOLEAN,
      allowNull: false
    },
    ladder_creation_date: {
      type: DataTypes.DATE,
      allowNull: false
    },
    ladder_fk_user: {
      type: DataTypes.INTEGER,
      allowNull: false
    },
    ladder_fk_game: {
      type: DataTypes.UUID,
      allowNull: false
    },
    ladder_fk_platforms: {
      type: DataTypes.ARRAY(DataTypes.UUID),
      allowNull: false
    }

  },
    {
      schema: 'ladder',
      tableName: 'ladders'
    });
}

Running Sequelize version 3.30.4 and postgreSQL version 9.6.

The intention is to set autoIncrement to true in order to generate UUID with postgreSQL uuid_generate_v4().

javascriptangularjspostgresqlsequelize.js

Answer №1

While I'm not a regular user of sequelize, it's important to note that using autoIncrement for non-sequential columns in PostgreSQL may not be the best approach. Instead, consider adding an extension for generating UUID numbers easily, as PostgreSQL does not have a default UUID number generator. You can find more information about this at https://www.postgresql.org/docs/9.4/static/uuid-ossp.html. I assume you have already added this extension.

The next step would involve utilizing the sequelize.fn function.

This function creates an object representing a database function, which can be used in search queries within both 'where' and 'order' clauses, as well as in defining default values for column definitions.

Thus, your solution should look something like:

ladder_id: {
    type: DataTypes.UUID,
    allowNull: false,
    primaryKey: true,
    default: sequelize.fn('uuid_generate_v4')
}

Answer №2

It seems like the autoIncrement setting in PostgreSQL is hardcoded to use the SERIAL type for columns, which may be causing conflicts with your UUID choice.

To resolve this issue, consider removing the autoincrement parameter and using the defaultValue instead:

return sequelize.define('Ladder', {
    ladder_id: {
      type: DataTypes.UUID,
      allowNull: false,
      primaryKey: true,
      defaultValue: UUIDV4
    },

Answer №3

student_id: {
    primaryKey: true,
    incrementByOne: true,
    dataType: Sequel.STRING
},
teacher_id: {
    referencesTo: {
        dataModel: 'educator',
        primarykey: 'teacher_id'
    },
    dataType: Sequel.STRING
}

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

The top choice for AngularJS: A trustworthy JSON viewer and editor module

Currently, I am working on enhancing my app by incorporating a json editor feature. I would appreciate any recommendations on which module you have experience with and believe is both stable and effective. The data I am working with is already in json for ...

jsonangularjs

Challenges with incrementing in Jquery's each loop and setTimeout

http://jsfiddle.net/fxLcy/ - an example showcasing the use of setTimeout. http://jsfiddle.net/fxLcy/1/ - this demo does not include setTimeout. Although all elements are correctly positioned, I am in need of that delayed animation =/ My goal is to arrang ...

javascriptjqueryhtmlcss

Error encountered during Postgres function creation: Language not specified. SQL state code: 42P13

I'm relatively new to working with functions. I attempted to create a function by following the instructions on this page - http://www.postgresqltutorial.com/creating-first-trigger-postgresql/. Unfortunately, I encountered an error. Below is the code ...

sqldatabasepostgresqltriggers

Tips for iterating through a collection of arrays with jQuery

I am facing an issue with looping through an array of arrays and updating values or adding new keys to each array. Here is my current setup: var values = []; values['123'] = []; values['456'] = []; values['123&apo ...

javascriptjqueryarrays

How can I transfer form data to a PHP variable using an AJAX request?

Encountering some difficulties, any insights? I have included only the necessary parts of the code. Essentially, I have an HTML form where I aim to extract the value from a field before submission, trigger an ajax call, and fill in another field. It seems ...

javascriptphpajaxforms

Managing JSON data through AJAX in ColdFusion

For my external API call using AJAX, I am incorporating a local API setup as an intermediate step. The process is as follows: The Ajax call sends data to localAPI.cfm. Within localAPI.cfm, there is a <cfhttp> tag to forward the data to an external ...

javascriptjqueryjsonajaxcoldfusion

How can you find the index of an HTML element while excluding any clearfix divs?

In the process of developing a CMS, I find myself in need of determining the index of the element I am currently working on. Consider the following stripped-down HTML structure: <div class="row"> <article class="col-md-4 col-sm-4 project" &g ...

javascriptjqueryhtml

Any ideas on how to potentially establish a default route based on conditions with react-router-dom v6?

Managing two pages, Page1 and Page2, requires conditional configuration for setting one as the homepage based on a specific condition. Additionally, all URLs must be prefixed with an ID. Take a look at the code snippet below: <Routes> <Route pat ...

javascriptreactjsreact-router-dom

Troubleshooting problems with the width of a Bootstrap navbar

I'm encountering a frustrating issue with my bootstrap menu. When I include the "navbar Form" in the menu, the width of the menu extends beyond the screen width in mobile mode (when resizing the browser window or viewing on a mobile device). Interesti ...

javascripthtmlcsstwitter-bootstraptwitter-bootstrap-3

Display the message "Please complete all required fields" on the AngularJS href when the necessary fields have not been filled out

Is there a way to implement input validation so that when a user clicks on a href link without filling out the required input fields, they see a message prompting them to fill in the fields? I tried changing the href to a button and it worked, but that&apo ...

angularjsvalidationinputhref

When attempting to host a web application built using the Impact JavaScript game engine on a local server, Chrome throws CORS errors

Currently, I am working on a webapp created with the Impact JS game engine that needs to run locally without using a localhost (using file:///C:/...). The issue I am facing is with Chrome, as it is blocking the loading of images (mainly png/jpg) from the m ...

javascripthtmlgoogle-chromecorsimpactjs

Can someone explain the process of adding a JavaScript state variable from one React component so that it can be utilized in other components?

In my Home.js component, I handle user sign up to the API and login. After receiving the token from the authorization header in the response, I save it in the state variable 'token'. This token is crucial for accessing the API in other component ...

javascriptreactjsjsonreact-nativerequest

Frontend utilizing the Next-auth Github Provider for Profile Consumption

After following the official documentation for implementing SSO with the Next-auth Github provider in my App, I encountered an issue where the Client API documentation suggested using useSession() to retrieve session information, but it was not returning t ...

javascriptnode.jsnext.jsnext-auth

Is there a type-safe alternative to the setTimeout function that I can use?

When running my tests, I encountered an issue with the setTimeout method making them run slower than desired. I initially attempted to address this by using "any" in my code... but that led to complaints from eslint and others. Now, I have implemented a ...

javascripttypescripttype-safety

Angular's forEach function seems to be stuck and not loop

I'm attempting to cycle through a list of objects in my Angular/Typescript code, but it's not working as expected. Here is the code snippet: businessList: RemoteDataSet<BusinessModel>; businessModel: BusinessModel; this.businessList.forE ...

angularjstypescript

Angular and Datepair seem to have trouble cooperating

I've been struggling to solve this issue for a few days now and I feel like it's time to seek help from you wonderful people. I am currently developing a calendar application using Angular along with the datepair/datepicker/timepicker libraries. ...

jqueryruby-on-railsangularjsdatepickertimepicker

Load Express JS router middleware conditionally based on certain conditions

In my Express JS code, I have implemented a middleware that defines specific end-points on a router for user login and logout. However, I am now integrating a new authentication method where the auth token is received from a different service. In this case ...

javascriptnode.jsexpress

Dynamic count down using JavaScript or jQuery

I am looking for a way to create a countdown timer that I can adjust the time interval for in my database. Basically, I have a timestamp in my database table that might change, and I want to check it every 30 seconds and update my countdown accordingly. H ...

javascriptphpjquerylive

On mobile devices, the code "location.assign(url)" may occasionally redirect to an incorrect URL, despite functioning correctly in the majority of instances

After setting up a page with a timeout that should automatically redirect to a specific URL after 60 minutes, I encountered an issue where the redirection sometimes leads to a loss of parameters in the URL. The JavaScript code added for this purpose is set ...

javascriptmobile

Retrieve the Date information and transfer it to another page using a combination of jQuery, JavaScript, and PHP

I feel defeated trying to solve this problem. Can anyone offer assistance in figuring this out? I've spent an entire day debugging with no success. I have two PHP files, index.php and home.php. In the index.php file, I include the Date range picker, ...

javascriptphpjquery