Saving view turns SELECT * into field list

Поиск
Список
Период
Сортировка
Искать
От
Ben Uphoff
Тема
Saving view turns SELECT * into field list
Дата
Msg-id
4748E0E4-9D2A-4D44-B20F-6749E8C989D7@villagemd.com
Список
Дерево обсуждения
Saving view turns SELECT * into field list Ben Uphoff <buphoff@villagemd.com>
Re: Saving view turns SELECT * into field list Tom Lane <tgl@sss.pgh.pa.us>
Re: Saving view turns SELECT * into field list Ben Madin <ben@ausvet.com.au>
Re: Saving view turns SELECT * into field list "David G. Johnston" <david.g.johnston@gmail.com>

Hey team – I’m sure this has come up, but my search engine skills couldn’t find an explanation:

 

Why, when I save a simple view like:

 

SELECT * FROM a_table

 

…does PostgreSQL turn the * into a field list like:

 

SELECT field1, field2, field3, field4 FROM a_table

 

?

 

This is super-frustrating, as it means I’ll have to manually change an aggregating “parent” view’s select lists every time I change the “child” views.

 

Thanks for any info. -Ben

******************* PLEASE NOTE ******************* This E-Mail/telefax message and any documents accompanying this transmission may contain information that is privileged, confidential, and/or exempt from disclosure under applicable law and is intended solely for the addressee(s) named above. If you are not the intended addressee/recipient, you are hereby notified that any use of, disclosure, copying, distribution, or reliance on the contents of this E-Mail/telefax information is strictly prohibited and may result in legal action against you. Please reply to the sender advising of the error in transmission and immediately delete/destroy the message and any accompanying documents. Thank you.
В списке pgsql-general по дате отправления
Предыдущее
От: David Steele
Дата:
Следующее
От: Tom Lane
Дата:
FAQ