Create Domain Error

Question

I am trying to define a new domain "rating_int" that I would be able to use in the table "Review". Anytime I try to execute this query, it returns this message:

ERROR: column "rating_int" does not exist

********** Error **********

ERROR: column "rating_int" does not exist

SQL state: 42703

I followed the exact same code format as the postgresql example and I do not know why my code is returning an error.

CREATE DOMAIN rating_int AS INTEGER
CHECK(rating_int > 0 AND rating_int <=10);

CREATE TABLE Review
(
    paper_id INTEGER,
   rv_email VARCHAR(55)     NOT NULL,
   reccomendation TEXT,
   a_comments TEXT,
   c_comments TEXT,
   technical_merit rating_int,
   readability rating_int,
   orginality rating_int,
   relevance rating_int,
   PRIMARY KEY(paper_id, rv_email),
   FOREIGN KEY(paper_id) REFERENCES Paper
   ON DELETE RESTRICT ON UPDATE CASCADE,
   FOREIGN KEY(rv_email) REFERENCES Reviewer
   ON DELETE SET NULL   ON UPDATE CASCADE
   );

Gordon Linoff · Accepted Answer · 2017-02-12 21:10:52Z

1

You use value, not the name of the domain. Like this:

CREATE DOMAIN rating_int AS INTEGER
    CONSTRAINT chk_rating_int CHECK (value > 0 AND value <= 10);

You don't actually need to give the constraint a name -- your error was rating_int instead of value. So this works:

CREATE DOMAIN rating_int AS INTEGER
    CHECK (value > 0 AND value <= 10);

However, I think it is a good idea to give constraints names.

Also, you might want to make the type a smallint or decimal(2), if you want to save on space.

answered Feb 12, 2017 at 21:10

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

stargazer Over a year ago

Thanks, my query executed with no problems. Can I ask why am I expected to use value rather than the name of the domain?

Gordon Linoff Over a year ago

@stargazer . . . That is how the syntax is defined.

Collectives™ on Stack Overflow

Create Domain Error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related