| 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: | Whole Thread | Raw Message | 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
| 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 |