Skip site navigation (1) Skip section navigation (2)

BUG #2215: Cannot restore backup cause of view's representaion

From: "Sokolov Yura" <funny_falcon(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2215: Cannot restore backup cause of view's representaion
Date: 2006-01-26 13:04:47
Message-ID: 20060126130447.CFD7AF0A2F@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2215
Logged by:          Sokolov Yura
Email address:      funny_falcon(at)mail(dot)ru
PostgreSQL version: 8.1.2
Operating system:   Windows XP SP2, Slackware 10.2
Description:        Cannot restore backup cause of view's representaion
Details: 

View's text representation is wrong, when row_value used inside a view.

Example:

--Create table and view

create table test
(
   i int4,
   j int4
);

create view test_v as
select (r.t).i,(r.t).j
from (select t.i,t.j,t  from test t) r
where r.i = 1;

/*
-- this is what pgadmin and plain text dump show
CREATE VIEW test_v AS
    SELECT (r.t).i AS i, (r.t).j AS j FROM (SELECT t.i, t.j, t.* AS t FROM
test t) r WHERE (r.i = 1);
*/

/*
-- this is how pg_restore throw pgadmin scold
pg_restore: [archiver (db)] could not execute query: ERROR:  column r.t does
not exist
    Command was: CREATE VIEW test_v AS
    SELECT (r.t).i AS i, (r.t).j AS j FROM (SELECT t.i, t.j, t.* AS t FROM
test t) r WHERE (r.i = 1);
*/

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-01-26 16:00:10
Subject: Re: BUG #2195: log_min_messages crash server when in DEBUG3 to
Previous:From: ISHIDA AkioDate: 2006-01-26 11:55:30
Subject: BUG #2214: release.sgml - Migration to version 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group