Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
> After dumping (by pg_dump) and restoring views becomes a tables
>
The problem is that views are dumped with anm extraneous "WHERE"
> ............................
> QUERY: COPY "t1" FROM stdin;
> CREATE RULE "_RETv1" AS ON SELECT TO "v1" WHERE DO INSTEAD SELECT "a" FROM
"t1";
> QUERY: CREATE RULE "_RETv1" AS ON SELECT TO "v1" WHERE DO INSTEAD SELECT "a"
FROM "t1";
...................................................++++++
> ERROR: parser: parse error at or near "do"
> EOF
Which causes this error and the rule (View) is not Created.
I don't know how the where clause gets in there but if you
edit the dump before restoring all is OK.
Keith.