Tim Kane <tim.kane@gmail.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