| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Tim Kane <tim(dot)kane(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: postgres_fdw foreign keys with default sequence |
| Date: | 2015-02-18 13:36:46 |
| Message-ID: | 1457828247.495495.1424266606165.JavaMail.yahoo@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tim Kane <tim(dot)kane(at)gmail(dot)com> wrote:
> CREATE MATERIALISED VIEW local.devices;
>
> CREATE test_table (device_id bigint FOREIGN KEY (device_id) REFERENCES local.devices (device_id) );
>
> ERROR: referenced relation "devices" is not a table
In the future, please show code that you have actually run. In
this case it's pretty easy to know how to answer, but in others it
may really draw out the process of helping you.
At this time materialized views do not support constraints, and may
not be referenced in foreign key definitions.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2015-02-18 13:52:16 | Re: pgaudit - an auditing extension for PostgreSQL |
| Previous Message | Simon Riggs | 2015-02-18 13:25:01 | Re: Auditing extension for PostgreSQL (Take 2) |