-
Notifications
You must be signed in to change notification settings - Fork 330
Description
I got error message for insert mix case column record:
warehouse = {"code":"0c956389","name":"TestWarehouse","address":"Test address","directory":"test dir","createdById":1,"createdOn":"2020-09-03T05:36:59.347Z"}
sqlinsert into warehouse ${ sql(warehouse, 'code', 'name', 'address', 'directory', 'createdById', 'createdOn') }
(node:34136) UnhandledPromiseRejectionWarning: Error: column "createdbyid" of relation "warehouse" does not exist
at Object.generic (/Users/hcheng/project/test/process/node_modules/postgres/lib/types.js:200:5)
at Object.ErrorResponse (/Users/hcheng/project/test/process/node_modules/postgres/lib/backend.js:124:33)
at Socket.data (/Users/hcheng/project/test/process/node_modules/postgres/lib/connection.js:167:25)
at Socket.emit (events.js:315:20)
at Socket.EventEmitter.emit (domain.js:485:12)
at addChunk (_stream_readable.js:300:12)
at readableAddChunk (_stream_readable.js:276:9)
at Socket.Readable.push (_stream_readable.js:217:10)
at TCP.onStreamRead (internal/stream_base_commons.js:186:23)
db table define:
select * from warehouse;
createdOn | modifiedOn | rowStatus | rowVersion | id | code | name | address | geoLocation | levels | directory | createdById | modifiedById
Thanks for help.