Chapter 6 - DB Seeding Issue Solution (checkInsertTargets)

[berkay-yuksel]

error {8} length:122 name:"error" severity:"ERROR" code:"42703" position:"33" file:"parse_target.c" line:"1075" routine:"checkInsertTargets"

The reason I was encountering the error above was that the 'users' table already existed in my database. If any of the tables from the example code { invoices, customers, revenue, users } already exist, you can resolve the issue by dropping the relevant table using a query like DROP TABLE users in the Data -> Query section on Vercel

Additionally, you can add error.message to the Response.json to provide a improved log of the error:

catch (error) {
  console.error('Seeding error:', error);
  await client.sql`ROLLBACK`;
  return Response.json({ error: error.message }, { status: 500 });
}