BUG #4688: Bug in cache. - Mailing list pgsql-bugs

From Oleg
Subject BUG #4688: Bug in cache.
Date
Msg-id 200903031048.n23Amd97002744@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4688: Bug in cache.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4688
Logged by:          Oleg
Email address:      serovOv@gmail.com
PostgreSQL version: last stable
Operating system:   CentOS
Description:        Bug in cache.
Details:

Demo sql:
ROLLBACK;
BEGIN;

CREATE TABLE bug_composite_type (
    text character varying(50)
);

CREATE TABLE bug_list (
    test bug_composite_type
);

INSERT INTO bug_list VALUES (ROW('text'));

ALTER TABLE bug_composite_type RENAME TO tmp_table;

CREATE TABLE bug_composite_type
(
    text character varying(250)
);

CREATE CAST (tmp_table AS composite_ad_texts)
    WITHOUT FUNCTION AS ASSIGNMENT;


ALTER TABLE bug_list ALTER test TYPE composite_ad_texts;

DROP CAST (tmp_table AS composite_ad_texts);
DROP TABLE tmp_table;

SELECT * FROM bug_list; -- bug
-- ERROR:  could not open relation with OID 395705050

pgsql-bugs by date:

Previous
From: "Dr. Björn Weitzig"
Date:
Subject: Re: BUG #4638: Bug with Geometry in Array
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4688: Bug in cache.