1. Vertabelo
  2. Errores
0
No es un bug

default values not quoted

Rob Hill hace 3 años • actualizado hace 3 años • 3

I have created a table with columns containing default values and the generated sql does not quote the value, causing the following failure message:

ERROR: cannot use column reference in DEFAULT expression

I also tried quoting the value in the "Default Value" property but in both cases the SQL generated failed to quote the vallue.

auto_renew boolean  NOT NULL DEFAULT FALSE,
En revisión
Adam Mościcki hace 3 años
No es un bug
Adam Mościcki hace 3 años

Hello,

This is an intended behavior. In fact, the "Default Value" property can be many things, i.e.:
- a constant, like FALSE, which indeed has to be quoted
- an expression like, nextval('sequence') which can't be quoted


Therefore we decided to not quote this property.


Hope this helps,
Adam

Rob Hill hace 3 años

OK.

But why, if I quote it, are the quotes ignored?

Servicio de atención al cliente por UserEcho