Baron Von Enablestein
DTDrizzle Team
•Created by Baron Von Enablestein on 4/30/2024 in #help
pgEnum conversion not working as expected
Hmmm, if I look at the full stack trace this might have to do with me using the RDS Data API:
{
"name": "DatabaseErrorException",
"location": "/var/runtime/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:871",
"message": "ERROR: column \"type\" is of type approval_request_type but expression is of type text; Hint: You will need to rewrite or cast the expression.; Position: 154; SQLState: 42804",
"stack": "DatabaseErrorException: ERROR: column \"type\" is of type approval_request_type but expression is of type text; Hint: You will need to rewrite or cast the expression.; Position: 154; SQLState: 42804\n at de_DatabaseErrorExceptionRes (/var/runtime/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:871:21)\n at de_CommandError (/var/runtime/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:791:19)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async /var/runtime/node_modules/@aws-sdk/node_modules/@smithy/middleware-serde/dist-cjs/index.js:35:20\n at async /var/runtime/node_modules/@aws-sdk/node_modules/@smithy/core/dist-cjs/index.js:165:18\n at async /var/runtime/node_modules/@aws-sdk/node_modules/@smithy/middleware-retry/dist-cjs/index.js:320:38\n at async /var/runtime/node_modules/@aws-sdk/middleware-logger/dist-cjs/index.js:33:22\n at async AwsDataApiPreparedQuery.values (/var/task/index.js:25140:20)\n at async AwsDataApiPreparedQuery.execute (/var/task/index.js:25111:20)\n at async insertApprovalRequest (/var/task/index.js:29434:35)"
}
{
"name": "DatabaseErrorException",
"location": "/var/runtime/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:871",
"message": "ERROR: column \"type\" is of type approval_request_type but expression is of type text; Hint: You will need to rewrite or cast the expression.; Position: 154; SQLState: 42804",
"stack": "DatabaseErrorException: ERROR: column \"type\" is of type approval_request_type but expression is of type text; Hint: You will need to rewrite or cast the expression.; Position: 154; SQLState: 42804\n at de_DatabaseErrorExceptionRes (/var/runtime/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:871:21)\n at de_CommandError (/var/runtime/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:791:19)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async /var/runtime/node_modules/@aws-sdk/node_modules/@smithy/middleware-serde/dist-cjs/index.js:35:20\n at async /var/runtime/node_modules/@aws-sdk/node_modules/@smithy/core/dist-cjs/index.js:165:18\n at async /var/runtime/node_modules/@aws-sdk/node_modules/@smithy/middleware-retry/dist-cjs/index.js:320:38\n at async /var/runtime/node_modules/@aws-sdk/middleware-logger/dist-cjs/index.js:33:22\n at async AwsDataApiPreparedQuery.values (/var/task/index.js:25140:20)\n at async AwsDataApiPreparedQuery.execute (/var/task/index.js:25111:20)\n at async insertApprovalRequest (/var/task/index.js:29434:35)"
}
2 replies