Re: Materialized views WIP patch

Antonin Houska <antonin.houska@gmail.com>

From: Antonin Houska <antonin.houska@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2012-11-16T21:02:05Z
Lists: pgsql-hackers
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 
> <mailto: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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Preserve intermediate .c files in coverage mode