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

Don Baccus <dhogaza(at)pacifier(dot)com> writes:
> I was able to fix my views by changing:
> create view foo as select * from bar;
> to:
> ...select * from bar bar;

Hmm, I think I see it.

create view foo as select * from int8_tbl;

$ pg_dump -t foo regression
\connect - postgres
CREATE TABLE "foo" (
"q1" int8,
"q2" int8
);
CREATE RULE "_RETfoo" AS ON SELECT TO foo DO INSTEAD SELECT int8_tbl.q1,
int8_tbl.q2 FROM int8_tbl (q1, q2);

IIRC, Thomas explained that the ANSI syntax says you *must* supply a
table alias if you are going to supply any column aliases in FROM.
The regurgitated rule violates that.

I guess this is another manifestation of the issue about the system
shoving in column "aliases" that the user never typed. pg_dump is
probably repeating what the backend told it. Think we'll have to
leave it unfixed till Thomas gets back.

It's also a reminder that the regress tests don't exercise pg_dump :-(

regards, tom lane