Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
Date
Msg-id 21342.1273172968@sss.pgh.pa.us
Whole thread Raw
In response to SELECT * in a CREATE VIEW statement doesn't update column set automatically  (Joseph Adams <joeyadams3.14159@gmail.com>)
Responses Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically
List pgsql-hackers
Tree view 
Joseph Adams <joeyadams3.14159@gmail.com> writes:
> This isn't exactly a bug, but it could be considered unintuitive
> behavior.

It's required by the SQL standard.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: max_standby_delay considered harmful
Next
From: Merlin Moncure
Date:
Subject: Re: SELECT * in a CREATE VIEW statement doesn't update column set automatically