Error deleting project: error: update or delete on table "projects" violates foreign key constraint "approval_requests_project_id_fkey" on table "approval_requests"
    at /home/viratlab/nodevenv/portalapi.aseries.in/20/lib/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async deleteProject (/home/viratlab/portalapi.aseries.in/controllers/project.controller.js:101:20) {
  length: 338,
  severity: 'ERROR',
  code: '23503',
  detail: 'Key (project_id)=(4) is still referenced from table "approval_requests".',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'approval_requests',
  column: undefined,
  dataType: undefined,
  constraint: 'approval_requests_project_id_fkey',
  file: 'ri_triggers.c',
  line: '3283',
  routine: 'ri_ReportViolation'
}
Error deleting project: error: update or delete on table "projects" violates foreign key constraint "pfr_documents_project_id_fkey" on table "pfr_documents"
    at /home/viratlab/nodevenv/portalapi.aseries.in/20/lib/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async deleteProject (/home/viratlab/portalapi.aseries.in/controllers/project.controller.js:101:20) {
  length: 318,
  severity: 'ERROR',
  code: '23503',
  detail: 'Key (project_id)=(3) is still referenced from table "pfr_documents".',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'pfr_documents',
  column: undefined,
  dataType: undefined,
  constraint: 'pfr_documents_project_id_fkey',
  file: 'ri_triggers.c',
  line: '3283',
  routine: 'ri_ReportViolation'
}
Error deleting project: error: update or delete on table "projects" violates foreign key constraint "approval_requests_project_id_fkey" on table "approval_requests"
    at /home/viratlab/nodevenv/portalapi.aseries.in/20/lib/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async deleteProject (/home/viratlab/portalapi.aseries.in/controllers/project.controller.js:101:20) {
  length: 338,
  severity: 'ERROR',
  code: '23503',
  detail: 'Key (project_id)=(5) is still referenced from table "approval_requests".',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'approval_requests',
  column: undefined,
  dataType: undefined,
  constraint: 'approval_requests_project_id_fkey',
  file: 'ri_triggers.c',
  line: '3283',
  routine: 'ri_ReportViolation'
}
