6.5 cvs: views doesn't survives after pg_dump

Started by Oleg Bartunovover 26 years ago2 messages
#1Oleg Bartunov
oleg@sai.msu.su

After dumping (by pg_dump) and restoring views becomes a tables

Here is a simple scenario:
1. createdb tview

2. create table t1 (a int4, b int4);
create view v1 as select a from t1;

3. pg_dump -z tview > tview.dump
4. destroydb tview
5. psql -e tview < tview.dump
............................
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

6. psql tview

tview=> \dt
Database    = tview
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | megera           | t1                               | table    |
 | megera           | v1                               | table    |
 +------------------+----------------------------------+----------+

tview=>

view t1 now becomes table v1 !

Regards,

Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Oleg Bartunov (#1)
Re: [HACKERS] 6.5 cvs: views doesn't survives after pg_dump

I assume this is fixed.

After dumping (by pg_dump) and restoring views becomes a tables

Here is a simple scenario:
1. createdb tview

2. create table t1 (a int4, b int4);
create view v1 as select a from t1;

3. pg_dump -z tview > tview.dump
4. destroydb tview
5. psql -e tview < tview.dump
............................
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

6. psql tview

tview=> \dt
Database    = tview
+------------------+----------------------------------+----------+
|  Owner           |             Relation             |   Type   |
+------------------+----------------------------------+----------+
| megera           | t1                               | table    |
| megera           | v1                               | table    |
+------------------+----------------------------------+----------+

tview=>

view t1 now becomes table v1 !

Regards,

Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026