DEV Community

01kg
01kg

Posted on

1

Supabase | cannot insert a non-DEFAULT value into column

Full Error:

PostgrestException(message: cannot
 insert a non-DEFAULT value into 
column "id", code: 428C9, details: 
Column "id" is an identity column 
defined as GENERATED ALWAYS., hint: 
Use OVERRIDING SYSTEM VALUE to override.)
Enter fullscreen mode Exit fullscreen mode

Table:

create table dog (
  id bigint generated always as identity primary key,
  name text,
  description text,
  user_id uuid references auth.users on delete cascade on update cascade
);
Enter fullscreen mode Exit fullscreen mode

Solution

According to this answer, no way to use OVERRIDING SYSTEM VALUE in Supabase.

Should use generated by default while creating "id" field.

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More