Re: Obvious data mismatch in View2 which basically SELECT * from View1

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: Obvious data mismatch in View2 which basically SELECT * from View1
Дата
Msg-id 649650653.3389440.1600345607165@mail.yahoo.com
обсуждение исходный текст
Ответ на Obvious data mismatch in View2 which basically SELECT * from View1  (Ben <bentenzha@outlook.com>)
Список pgsql-general
Дерево обсуждения


>I haven't replaced the broken View2 yet. >Hope someone can point me to some >further investigation.

Did you look at the actual definition of view2. Like all RDBMS PG materializes the Ddl as it existed at the time of creation and converts it into an in line sql.
There is a possibility it may be different than what you think.

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: PostgreSQL processes use large amount of private memory on Windows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL processes use large amount of private memory on Windows