Bug with temporary child of a permanent table after recovery - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Bug with temporary child of a permanent table after recovery
Date
Msg-id 50CB1455.3080002@vmware.com
Whole thread Raw
Responses Re: Bug with temporary child of a permanent table after recovery
List pgsql-bugs
Spotted by accident while working on a patch:

Open psql and do:

CREATE TABLE uctest(f1 int, f2 text);
-- Create a temporary child of the permanent table
CREATE TEMP TABLE ucchild () inherits (uctest);

In another terminal:
pg_ctl stop -m immediate
pg_ctl start

psql (9.3devel)
Type "help" for help.

postgres=# SELECT * FROM uctest;
ERROR:  could not open file "base/12030/t2_16392": No such file or directory

This goes back to 9.1.

- Heikki

pgsql-bugs by date:

Previous
From: daniel@heroku.com
Date:
Subject: BUG #7753: Cannot promote out of hot standby
Next
From: Simon Riggs
Date:
Subject: Re: BUG #7752: FATAL btree error on PITR