Re: [HACKERS] interesting observatation regarding views and V7.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] interesting observatation regarding views and V7.0
Дата
Msg-id 25724.951755786@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] interesting observatation regarding views and V7.0  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>> Something else we might consider as a stopgap is to resurrect the
>> "compressed text" datatype that Jan wrote, and then removed in
>> anticipation of having TOAST.

> Naw, the above should be easier all around.

When you finish catching up on your mail, you'll find lztext is already
back in ;-).  At this point, whether you change the representation is
pretty much irrelevant for rule size, I think.  However, I am still
concerned by the hack I had to put into ruleutils.c to get pg_dump
to produce valid output for cases likecreate view foo as select * from int8_tbl;
See the note and code at about line 1000 of utils/adt/ruleutils.c.
Ideally we want to be able to tell from the parsetree whether the user
wrote any column aliases or not (and if possible, distinguish the ones
he wrote from any that got added by the system).  So that may force
a representation change anyway.
        regards, tom lane


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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] Web page on bug reports
Следующее
От: "Joaquin Eduardo Monje"
Дата:
Сообщение: ask sybase - postgres