trying to have multiple tables for different projects in vercel postgres using drizzle
I followed Theo's react tutorial and had a t3-project_image table that I use with it on vercel storage.
I am creating a new project that is an e-comm-site and it has the following tables
e-comm-site_account
e-comm-site_user
e-comm-site_verification_token
e-comm-site_session
When I do db:push with schema
I get the following error:
severity_local: 'ERROR',
severity: 'ERROR',
code: '2BP01',
detail: 'default value for column id of table "t3-project_image" depends on sequence "t3-project_image_id_seq"',
hint: 'Use DROP ... CASCADE to drop the dependent objects too.',
file: 'dependency.c',
line: '1204',
routine: 'reportDependentObjects'
}
How do I remove the sequence dependency without deleting or making that table unusable for my other project?
I am creating a new project that is an e-comm-site and it has the following tables
e-comm-site_account
e-comm-site_user
e-comm-site_verification_token
e-comm-site_session
When I do db:push with schema
I get the following error:
severity_local: 'ERROR',
severity: 'ERROR',
code: '2BP01',
detail: 'default value for column id of table "t3-project_image" depends on sequence "t3-project_image_id_seq"',
hint: 'Use DROP ... CASCADE to drop the dependent objects too.',
file: 'dependency.c',
line: '1204',
routine: 'reportDependentObjects'
}
How do I remove the sequence dependency without deleting or making that table unusable for my other project?
