[BUGS] Problem using pg_dump going from 7.0.3 to 7.1beta3

[Bruno Wolff III]

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.

[BUGS] to_char appears fixed in 7.1beta3

[Bruno Wolff III]

A problem I reported a few weeks ago here using to_char to do a conversion
to roman numerals with many of the values being null doesn't seem to be
a problem in 7.1beta3.

[BUGS] possible 7.1beta3 bug with union and order by a function

[Bruno Wolff III]

The query below used to work with 7.0.3. If I change 'lower(title)' to
'title' in the order by clause, then the query is accepted.

area=> select code, wbc.gameid, title from games, wbc where wbc.gameid = games.gameid 
union select code, null, null as title from wbc where gameid is null order by code, 
lower(title);
ERROR:  Attribute 'title' not found