SQL Error when trying to alter column

Question

I add trying to add a method to be the defualt value of an existing SQL Table Column:

 ALTER TABLE Category ALTER COLUMN category_course 
   CONSTRAINT cat_other_course DEFAULT otherCourse();

However I keep getting this error:

ERROR:  syntax error at or near "CONSTRAINT"
LINE 2: ALTER TABLE Category ALTER COLUMN category_course CONSTRAINT...
                                                      ^
********** Error **********

ERROR: syntax error at or near "CONSTRAINT"
SQL state: 42601

NB: Yes, Category (table) category_course (column) and otherCourse() (function) all exist.

stackoverflow.com/a/4745365/3270427

McNets
– McNets

2017-06-05 10:13:28 +00:00
Commented Jun 5, 2017 at 10:13 — McNets
– McNets, Commented Jun 5, 2017 at 10:13

Rob Blagg · Accepted Answer · 2017-06-05 10:37:53Z

1

You need to add SET before DEFAULT. Hope this helps.

ALTER TABLE Category ALTER COLUMN category_course 
CONSTRAINT cat_other_course SET DEFAULT otherCourse();

answered Jun 5, 2017 at 10:37

Rob Blagg

2904 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Error when trying to alter column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related