https://serverless-stack.com/ logo
Join Slack
Powered by
With RDS, can we use the aurora serverless v2 and ...
# sst
j
With RDS, can we use the aurora serverless v2 and therefore PostreSQL 13.4?
t
Our rds construct only supports v1
We don't really feel v2 is a good fit for serverless yet
j
Ahh ok, the issue I’m coming up against is that I want to define a column which is an array of enum values, but whilst I can create the table and execute an INSERT, I can’t select the record back and I get this error
Copy code
BadRequestException: Array of type 'zones' is not supported
t
That's a response from the data api?
Haven't tried with an enum yet
j
Copy code
BadRequestException: Array of type 'zones' is not supported
    at Object.extractError (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/protocol/json.js:52:27)
    at Request.extractError (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/protocol/rest_json.js:49:8)
    at Request.callListeners (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/sequential_executor.js:106:20)
    at Request.emit (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/sequential_executor.js:78:10)
    at Request.emit (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/request.js:686:14)
    at Request.transition (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/request.js:22:10)
    at AcceptorStateMachine.runTo (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/state_machine.js:14:12)
    at /Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/state_machine.js:26:10
    at Request.<anonymous> (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/request.js:38:9)
    at Request.<anonymous> (/Users/jamlen/dev/src/github.com/tfgm/bus-reform-ticketing/node_modules/aws-sdk/lib/request.js:688:12) {
  code: 'BadRequestException',
thats the full error
and it fails in the Console RDS window if I just try 
SELECT * FROM product
could it be an issue with the 
"kysely-data-api"
t
Yeah I don't think I tested enums
I'll check but won't be able to get to this until tomorrow
j
don’t know if this works for you, but this is the basic detail I’m trying http://www.sqlfiddle.com/#!17/d4425b/4
I did wonder if it didn’t like my use of 
zones
, maybe a reserved word, but it errors with the same with a different name
@thdxr also just noticed 
BadRequestException: Currency types are not supported
when using 
.addColumn("cost", "money", (col) => col.notNull())
Did you manage to take a look at support for array of enums?
Open in Slack
PreviousNext
Powered by