Re: [HACKERS] pg_dump

Jan Wieck wrote:

> > I'm convinced that pg_dump / psql restore doesn't seem to restore VIEWs
> > properly. Anybody else seen this?
> 
>     More details please!

It seems to be extremely easy to reproduce...

chris=> create table foo(a int4, b int4);
CREATE
chris=> insert into foo values(3, 4);
INSERT 1484426 1
chris=> create view bar as SELECT a + b FROM foo;
CREATE
chris=> select * from bar;
?column?
--------      7
(1 row)

EOFis=> 
chris@tech!26!bash:~$ pg_dump chris -o >foo
chris@tech!27!bash:~$ createdb foobar
chris@tech!28!bash:~$ psql !$  select * from foo;
a|b
-+-
3|4
(1 row)

foobar=> select * from bar;
?column?
--------
(0 rows)

foobar=>