Problem using pg_dump going from 7.0.3 to 7.1beta3
Bruno Wolff III <bruno@wolff.to>
From: Bruno Wolff III <bruno@wolff.to>
To: pgsql-bugs@postgresql.org
Date: 2001-01-10T05:00:59Z
Lists: pgsql-bugs
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.