Re: Materialized views WIP patch

From: Antonin Houska <antonin(dot)houska(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Materialized views WIP patch
Date: 2012-11-16 21:02:05
Message-ID: 50A6A9CD.1030702@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)gmx(dot)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(at)mail(dot)com
> <mailto:kgrittn(at)mail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2012-11-16 21:20:02 Re: Materialized views WIP patch
Previous Message Kohei KaiGai 2012-11-16 20:09:05 Re: [v9.3] writable foreign tables