Column names - time
От | Lee Kindness |
---|---|
Тема | Column names - time |
Дата | |
Msg-id | 15308.6463.461957.320770@elsick.csl.co.uk обсуждение исходный текст |
Ответы |
Re: Column names - time
|
Список | pgsql-hackers |
In moving from 7.1.3 to 7.2devel (for bug fixes) we've encountered a problem with a, previously valid, column name: time. In 7.1.3 the following worked: CREATE TABLE test(time INTEGER); while in 7.2devel it results in a parse error: ERROR: parser: parse error at or near "time" Looking at the source I see this is a result of 'time' being added to ColLabel in backend/parser/gram.y earlier this month. This effects interface code and database migration using pg_dump. Obviously a new column name will have to be used, however is there a definitive list of keywords to avoid so such an occurance wouldn't happen in a production system? Currently these include: abort all analyse analyze and any asc between binary bit both case cast char character check cluster coalesce collate columnconstraint copy cross current_date current_time current_timestamp current_user dec decimal default deferrable descdistinct do else end except exists explain extract false float for foreign freeze from full global group having ilikeinitially in inner intersect into inout is isnull join leading left like limit listen load local lock move natural ncharnew not notnull nullif null numeric off offset old on only or order out outer overlaps position precision primary publicreferences reset right select session_user setof show some substring table then time timestamp to trailing transactiontrim true union unique unknown user using vacuum varchar verbose when where Best Regards, Lee Kindness..
В списке pgsql-hackers по дате отправления: