Bug with temporary child of a permanent table after recovery

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Bug with temporary child of a permanent table after recovery
Date: 2012-12-14 11:58:13
Message-ID: 50CB1455.3080002@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Simon Riggs 2012-12-14 14:04:26 Re: BUG #7752: FATAL btree error on PITR
Previous Message daniel 2012-12-12 21:36:23 BUG #7753: Cannot promote out of hot standby