Re: Table modification
От | Jean-Michel POURE |
---|---|
Тема | Re: Table modification |
Дата | |
Msg-id | 4.2.0.58.20011002113447.00a728a0@pop.freesurf.fr обсуждение исходный текст |
Ответ на | Table modification (Jean-Michel POURE <jm.poure@freesurf.fr>) |
Список | pgadmin-hackers |
>This is the correct way to do it, though I appreciate your problem with >large tables. Perhaps (for Table objects only) we should have a >Tables.DeferRebuild property. When set true, all rebuilds triggered by mods >of individual properties or collections will get queued up until an update >method is fired. That way, the update method can reduce all the required >rebuilds that are queued up into as small an operation as possible. > >What do you think? Agreed. Another question: how do we enable table reorganization (i.e. change the order of columns)? > > Do I miss something? >I don't think so. I would suggest that we both sleep on how to achieve the >above for a while - in the meantime look at the more simple mods like >updating functions/views/triggers. Agreed. What are your plans as regards functions/views/triggers? Do you confirm creating objects in their OID order should work for solving dependencies? Cheers, Jean-Michel
В списке pgadmin-hackers по дате отправления: