lobos icon indicating copy to clipboard operation
lobos copied to clipboard

how to remove a column constraint

Open mylesmegyesi opened this issue 13 years ago • 2 comments

Currently, I have a column that has a "NOT NULL" constraint and I need to remove it. So far, I haven't found a way to this using the DSL. The only solution I have found is to execute raw SQL like so:

(raw-update "ALTER TABLE table_name ALTER COLUMN column_name DROP NOT NULL")

Is there a way to do this through the DSL that I have missed?

mylesmegyesi avatar Apr 03 '13 14:04 mylesmegyesi

How did you get (raw-update ...) working? When I use it I get an error java.lang.Exception: no current database connection.

sthomp avatar Aug 12 '15 20:08 sthomp

Honestly, its been years since I worked with lobos and don't even have access to the offending code anymore. So, I won't be able to provide much help in reproducing the error anymore.

mylesmegyesi avatar Aug 12 '15 20:08 mylesmegyesi