At 03:27 PM 2/21/00 -0500, Tom Lane wrote:
>I don't like shipping betas with broken pg_dump; that makes life
>unreasonably difficult for beta testers, if we have to force another
>initdb before release. So I put in a quick hack solution: don't print
>the column alias list at all unless there is a table alias. This makes
>the rule's FROM clause conform to ANSI syntax. If you actually did
>write
> create view foo as SELECT alias FROM table table (alias);
>then it will dump as
> create view foo as SELECT table.realcolname AS alias FROM table;
>but there's no harm done. Better solution needed but I'll let Thomas
>provide it.
EXCELLENT!
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.