Actually the default value (here the call of the nextval-procedure) is defined in the db table (because it is a serial column).
The problem is, that tersus pass a NULL value to postgres and postgres says that it can't insert it because of the non-null constraint.
Contrary to MySQL, postgres doesn't insert the DEFAULT value when it receives a NULL value. It needs the ecplicit call of DEFAULT instead. Therefore I want tersus to pass the DEFAULT keyword.
As workaround I'm thinking about
1.) calling the nextval-procedure with the Call Procedure plugin before the INSERT (to retrieve the ID)
and after that
2.) doing the INSERT with the retrieved ID.
Could you explain your suggestion with the Update plugin?
ciao, kkg
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign