Cannot ADD CONSTRAINT in Postgresql

Question

I am having trouble with what I would think is a pretty simple constraint issue in postgres.

Ruinning:

ALTER TABLE rss_feed_list ADD CONSTRAINT status_type CHECK (feed_status = 'active' OR feed_status 'inactive');

returns the error:

ERROR: type "feed_status" does not exist

psur · Accepted Answer · 2012-10-12 06:06:48Z

2

There is no equals sign here:

OR feed_status 'inactive'

It probably should be:

OR feed_status = 'inactive'

answered Oct 12, 2012 at 6:06

psur

4,53930 silver badges37 bronze badges

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

1 Answer 1