Hi Andrus, the switch is durring runtime, so it's not defined at start up. The trigger is e.g. a checkbox in the ui where the user can decide if he want to read from archive. One idea was to create a view over archive and real table, because it's only read only necessary.
Andrus Adamchik <and...@objectstyle.org> schrieb am Fri Dec 19 2014 at 08:22:26: > I guess the answer depends on what "easily" means. So a few questions to > clarify the scenario: > > When you start an app, do you already know whether it will read from > regular or archive tables? If not, what event triggers the switch in the > running app? Is this for all sessions or just specific users? > > Andrus > > > On Dec 19, 2014, at 10:08 AM, Markus Reich <markus.re...@markusreich.at> > wrote: > > > > Hi, > > > > I need some hints for a very special issue :-) > > We have archived old entries of our tables to shadow tables, which have > > exactly the same columns structure as the source table. > > > > No we need to have a possibility to switch easily between real and > > shadowtable. > > Maybe someone already is/was facing such a constellation? > > > > thx > > Meex > >
