Joe Conway <[EMAIL PROTECTED]> writes: > I see we just recently made the word "value" reserved: > >http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/parser/keywords.c.diff?r1=1.130&r2=1.131 > I noticed it because it breaks the contrib/tablefunc regression test. ISTM > like this will break quite a few applications.
I'm not thrilled about it either. I wonder whether we could hack up something so that domain check constraints parse VALUE as a variable name instead of a reserved keyword? Without some such technique I think we're kinda stuck, because the spec is perfectly clear about how to write domain check constraints. (And, to be fair, SQL92 is also perfectly clear that VALUE is a reserved word; people griping about this won't have a lot of ground to stand on. But I agree it'd be worth trying to find an alternative implementation that doesn't reserve the keyword.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])