Re: Can't recreate view from backup

"Tim Knowles" <timknowles(at)ametco(dot)co(dot)uk> writes:
> I have a view which uses 3 subselects (if more info is required I've
> included the my SQL and the view that is created at the end). When I create
> the view the PostgreSQL creates the subselect with two fields (I guess it's
> the group by clause that may be causing this). The view works fine even
> though when I use \d to describe it, it looks like it returns more than one
> field - although it doesn't). However when I use pg_dump to back it up and
> then recreate the db I get an error that the subselect must only have one
> field.

This is fixed in 7.1.

Note that the above is by no means the worst of the problems that
grouped views will give you in 7.0.* and before :-(

regards, tom lane