You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When a sequence is used as the default value for a column, the NEXT VALUE FOR <sequence name> or nextval(<sequence name) string is used as a literal default value.
The correct behaviour would be to exclude the field from the insert if it is empty so to trigger the default value behaviour in the db.
A less correct but still acceptable behaviour would be to use the value as a raw value without quoting so the db executes the statement and correctly inserts the next sequence value.
The text was updated successfully, but these errors were encountered:
When a sequence is used as the default value for a column, the
NEXT VALUE FOR <sequence name>
ornextval(<sequence name)
string is used as a literal default value.The correct behaviour would be to exclude the field from the insert if it is empty so to trigger the default value behaviour in the db.
A less correct but still acceptable behaviour would be to use the value as a raw value without quoting so the db executes the statement and correctly inserts the next sequence value.
The text was updated successfully, but these errors were encountered: