I was moving a small database I had from 7.0.3 to 7.1beta3 using pgdump
and had a problem with a view. The I got a syntax error when the rule
corresponding to the view was being processed. While looking around I
noticed that the dump file created a table with the name of the view
instead of creating a view. Maybe that is just the way things work
when you create views using rules instead of the create view command,
I don't know. To use the dump file I just used it as input to psql.
If this is something that isn't already known I can make the pg_dump
output file available for people to look at.
pgsql-bugs by date
|Next:||From: Bruno Wolff III||Date: 2001-01-10 05:10:54|
|Subject: to_char appears fixed in 7.1beta3|
|Previous:||From: Mitchell Brandsma||Date: 2001-01-10 04:28:03|
|Subject: Interval bug|