On Mon, 2024-11-25 at 06:08 +, Shaun Robinson wrote:
> I'm currently testing an application with Postgres 17.2 and am getting an
> error
> when creating a materialized view which works in version 16 and below. The sql
> works fine running as a query, but adding the create materialized view bre
Hi David,
I've created a basic example which produces the issue for me and the SQL is
below.
Thanks
Shaun
create table diagnosisTest
(
id serial primary key,
icd_code varchar(10)
);
create table encounterTest
(
id serial primary key,
dx1 integer,
dx2 integer,
dx3 integer,
dx4 integer,
dx5 inte
On Mon, 25 Nov 2024, 06:08 Shaun Robinson,
wrote:
> Hi,
>
> I'm currently testing an application with Postgres 17.2 and am getting an
> error when creating a materialized view which works in version 16 and
> below. The sql works fine running as a query, but adding the
> create materialized view b
