Comments (2)
This is related to how the id property is defined for the Role model. It doesn’t have the generated flag set to true. As a result, the automigrate() doesn’t create a serial id.
I’ll check if we should fix that in strongloop/loopback repo.
Thanks,
Raymond Feng
Co-Founder and Architect @ StrongLoop, Inc.
StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.
On May 13, 2014, at 11:56 AM, Dilip Kr. Shukla [email protected] wrote:
I am getting following error while trying to create a new role over REST interface, if I am not passing id manually. While manually passing id is saving the data. Which should not happen and id should be auto generated, unless I am missing here some thing..
{
-error: {
name: "error"
status: 500
message: "null value in column "
id " violates not-null constraint"
length: 246
severity: "ERROR"
code: "23502"
detail: "Failing row contains (null, adminjk, nj, 2014-05-14 00:18:20+05:30, 2014-05-14 00:18:20+05:30)."
file: "src\backend\executor\execMain.c"
line: "1611"
routine: "ExecConstraints"
stack: "error: null value in column "
id " violates not-null constraint at Connection.parseE (E:\projects\Git\SourceTree\ConverBiz\SecondarySales\apiss\node_modules\loopback-connector-postgresql\node_modules\pg\lib\connection.js:521:11) at Connection.parseMessage (E:\projects\Git\SourceTree\ConverBiz\SecondarySales\apiss\node_modules\loopback-connector-postgresql\node_modules\pg\lib\connection.js:351:17) at Socket. (E:\projects\Git\SourceTree\ConverBiz\SecondarySales\apiss\node_modules\loopback-connector-postgresql\node_modules\pg\lib\connection.js:101:22) at Socket.EventEmitter.emit (events.js:95:17) at Socket. (stream_readable.js:746:14) at Socket.EventEmitter.emit (events.js:92:17) at emitReadable (_stream_readable.js:408:10) at emitReadable (_stream_readable.js:404:5) at readableAddChunk (_stream_readable.js:165:9) at Socket.Readable.push (_stream_readable.js:127:10)"—
Reply to this email directly or view it on GitHub.
from loopback-connector-postgresql.
Cleaning up old issues, looks like fixed by strongloop/loopback#254, closing issue.
from loopback-connector-postgresql.
Related Issues (20)
- Postgresql column as text[] or character varying() is returning data as string HOT 8
- Query with AND & OR combination is not working HOT 2
- Error when using transaction timeout HOT 6
- Postgres support > 9.x HOT 4
- LB4 with [email protected] causing SSL Error HOT 4
- eq object (JSON columns) doesn't work HOT 6
- Error: syntax error at or near ")"
- Support for Full Text Search
- Option to use joins instead of multiple calls for relations. HOT 1
- Release called on client which has already been released to the pool HOT 2
- Doesn't scramble the where correctly
- If url is empty string in config server crashes HOT 2
- Dependency Dashboard
- Add back Node.js v12 tests HOT 4
- Support bulk insert in one query using newly added createAll() in connector
- Error: Postgresql column as jsonb returning data as string using createAll() method HOT 2
- MongoDB extended operator rules erroneously applied to SQL databases and json bodies
- Default values in Models properties totally being ignored when using migrateschema. HOT 1
- Support for overlaps json operator
- Getting 5000ms Timeout error while connecting Postgres - I'm using node version 16.0.0, still running into the same problem. And I'm using the latest Postgres connector: `^7.0.1`. HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from loopback-connector-postgresql.