Horton

Re: [HACKERS] Beta for 4:30AST ... ?

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ed Loehr <eloehr@austin.rr.com>, The Hermit Hacker <scrappy@hub.org>, pgsql-hackers@postgreSQL.org
Date: 2000-02-21T20:28:28Z
Lists: pgsql-hackers 
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 Service and other goodies at
  http://donb.photo.net.