Postgres Pro
Downloads
Home   >   mailing lists

Re: Materialized views WIP patch - Mailing list pgsql-hackers

From Antonin Houska
Subject Re: Materialized views WIP patch
Date
Msg-id 50A6A9CD.1030702@gmail.com
Whole thread Raw
In response to Re: Materialized views WIP patch  (Thom Brown <thom@linux.com>)
List pgsql-hackers
Tree view
By chance (?) I got similar one today too, when dropping extension:

ERROR:  could not open file "base/12623/12548": No such file or directory

I thought something might have gone wrong during Linux upgrade 2 days ago, but it's not likely that we both have the issue.

I wonder if something is broken in the catalog. The last commit I have in my environment is

commit 4af3dda13601d859a20425e3554533fde0549056
Author: Peter Eisentraut <peter_e@gmx.net>
Date:   Sun Oct 28 10:35:46 2012 -0400

Kind regards,
Tony.

On 11/16/2012 06:14 PM, Thom Brown wrote:
On 15 November 2012 02:28, Kevin Grittner <kgrittn@mail.com> wrote:
Attached is a patch that...

 Got this error:

postgres=# create view v_test as select 1;
CREATE VIEW
postgres=# create materialized view mv_test as select * from v_test;
ERROR:  could not open file "base/12064/16425": No such file or directory

--
Thom

pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.3] writable foreign tables
Next
From: Josh Berkus
Date:
Subject: Re: Materialized views WIP patch