ALTER TABLE ADD COLUMN syntax question.

Поиск
Список
Период
Сортировка
От Robert B. Easter
Тема ALTER TABLE ADD COLUMN syntax question.
Дата
Msg-id 00070523563709.01354@comptechnews
обсуждение исходный текст
Список pgsql-sql
I used the command below to alter a table and it took with no problem, but the
REFERENCES appears to have been ignored since I can put invalid numbers into
last_post_id.  Are there plans to add the ability to specify column
constrainsts with ALTER TABLE ADD COLUMN in the future?  For now, I suppose I
can use ALTER TABLE ADD CONSTRAINT to make a table constraint for last_post_id.I hope it will not make things too slow.
Are table constraints slower than
 
column constraints? 

ALTER TABLE topic ADD COLUMN last_post_id INTEGER REFERENCES post ON DELETE
SET NULL;
--         Robert


В списке pgsql-sql по дате отправления:

Предыдущее
От: Paul McGarry
Дата:
Сообщение: Re: ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: ExecEvalAggref: no aggregates in this expressioncontext