After diligently following the guidelines provided by Vercel for setting up Postgres, I encountered an issue when testing my endpoint:
{
error: {
name: "NeonDbError",
code: "42P07"
}
}
Below is the code snippet of my endpoint:
import { NextResponse } from "next/server";
import { sql } from '@vercel/postgres';
export async function GET() {
try {
const result =
await sql`CREATE TABLE Pets ( Name varchar(255), Owner varchar(255) );`;
return NextResponse.json({ result });
} catch (error) {
return NextResponse.json({ error }, { status: 500 });
}
}In addition, I have configured all necessary variables in my .env.development.local file.