Re: patch: Add columns via CREATE OR REPLACE VIEW

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: patch: Add columns via CREATE OR REPLACE VIEW
Дата
Msg-id 20080807154908.GI4171@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: patch: Add columns via CREATE OR REPLACE VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: patch: Add columns via CREATE OR REPLACE VIEW
Список pgsql-hackers
Tom Lane escribió:

> But it seems hard to tell the difference between a "rename" and a
> "drop".  I think that we aren't going to get far on this until we
> decide what we will consider to be the identity of a view column.
> With regular tables the attnum is a persistent identifier, but that
> doesn't seem to play nicely for REPLACE VIEW, at least not if you're
> wanting to allow people to remove columns from their view definitions.

Hmm, maybe we need to pull off the project to separate logical attribute
number from physical and position.  It sounds like it could make it
easier for view modification.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Infrastructure changes for recovery
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Infrastructure changes for recovery