Auth table columns missing from schema load

I've encountered an issue while trying to pull the remote database and data to use for seeds. It appeared that some needed columns in the auth schema were not created.

After pulling the remote database (

supabase db pull

supabase db pull

) and then dumping the DB records into a SQL file (

supabase db dump --data-only -f ./supabase/seed.sql

supabase db dump --data-only -f ./supabase/seed.sql

), I encountered an error while trying to reset and seed the database. This error showed that some columns in two auth tables were missing. The

auth.sessions

auth.sessions

table was missing the

tag

tag

(text) column, and the

auth.identities

auth.identities

table was missing the

provider_id

provider_id

(text) column.

I was able to remedy this by adding these two columns in my first migration. This migration file I used was from running

supabase db pull

supabase db pull

ALTER TABLE auth.sessions
ADD "tag" "text";

ALTER TABLE auth.identities
ADD "provider_id" "text";

ALTER TABLE auth.sessions
ADD "tag" "text";

ALTER TABLE auth.identities
ADD "provider_id" "text";

After running,

supabase db reset

supabase db reset

these columns are added, and the dumped seed file worked. Is this intended or should these columns be added to the auth schema somewhere?

Supabase•3y ago

Hoobie

Auth table columns missing from schema load

supabase db pull

supabase db pull

) and then dumping the DB records into a SQL file (

supabase db dump --data-only -f ./supabase/seed.sql

supabase db dump --data-only -f ./supabase/seed.sql

), I encountered an error while trying to reset and seed the database. This error showed that some columns in two auth tables were missing. The

auth.sessions

auth.sessions

table was missing the

tag

tag

(text) column, and the

auth.identities

auth.identities

table was missing the

provider_id

provider_id

(text) column.

I was able to remedy this by adding these two columns in my first migration. This migration file I used was from running

supabase db pull

supabase db pull

ALTER TABLE auth.sessions
ADD "tag" "text";

ALTER TABLE auth.identities
ADD "provider_id" "text";

ALTER TABLE auth.sessions
ADD "tag" "text";

ALTER TABLE auth.identities
ADD "provider_id" "text";

After running,

supabase db reset

supabase db reset

these columns are added, and the dumped seed file worked. Is this intended or should these columns be added to the auth schema somewhere?

Auth table columns missing from schema load

Similar Threads

Auth table columns missing from schema load

Similar Threads

Similar Threads

Similar Threads