Re: add_missing_from breaks existing views
От | Neil Conway |
---|---|
Тема | Re: add_missing_from breaks existing views |
Дата | |
Msg-id | 1130277532.8506.87.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | add_missing_from breaks existing views (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: add_missing_from breaks existing views
|
Список | pgsql-hackers |
On Tue, 2005-25-10 at 17:43 -0400, Tom Lane wrote: > What I suggest we do about this is change addImplicitRTE() to set > inFromCl true for implicitly added RTEs, so that the view rule will > later be dumped as if the query had been written per spec. Sounds reasonable. I wonder if this should be backpatched -- ISTM the proper representation of the view is with an explicit FROM list anyway, and making the correctness of view definition dependent on a GUC variable is only asking for trouble. > 1. Tell people they may have to set add_missing_from = true to reload > a dump that contains such views. pg_dump could itself specify "SET add_missing_from = true" before view definitions. However, that is definitely a hack :( -Neil
В списке pgsql-hackers по дате отправления: