BUG #4688: Bug in cache.

From: "Oleg" <serovOv(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4688: Bug in cache.
Date: 2009-03-03 10:48:39
Message-ID: 200903031048.n23Amd97002744@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4688
Logged by: Oleg
Email address: serovOv(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2009-03-03 11:21:30 Re: BUG #4688: Bug in cache.
Previous Message Dr. Björn Weitzig 2009-03-03 08:57:38 Re: BUG #4638: Bug with Geometry in Array