Re: Add constraint in a Materialized View

Поиск
Список
Период
Сортировка
От Nico Williams
Тема Re: Add constraint in a Materialized View
Дата
Msg-id 20180720190646.GS9712@localhost
обсуждение исходный текст
Ответ на Add constraint in a Materialized View  (Kaye Ann Ignacio <kaye.ignacio@proceedit.com>)
Список pgsql-hackers
On Wed, Jul 18, 2018 at 09:28:19AM +0200, Kaye Ann Ignacio wrote:
> I'm trying to add a foreign constraint in my local table to reference a
> column in a materialized view, is it possible to alter this materialized
> view by adding a primary key constraint?

It's not, but I'm working on a patch for that and much more.  Basically,
I want to integrate something like
https://github.com/twosigma/postgresql-contrib/blob/master/mat_views.sql

I currently use that code instead of PG native materialized views.

Nico
-- 


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