subject:"\[GENERAL\] Solution for Synonyms"

Re: [GENERAL] Solution for Synonyms

2013-11-25 Thread Albe Laurenz

Thomas Kellerer wrote: > mrprice22 wrote on 22.11.2013 19:25: >> We are in the process of moving from Oracle to PostgreSQL. We use a stored >> procedure to populate some reporting tables once an hour. There are two >> sets of these tables, set A and set B. We use synonyms to point to the >> “act

Re: [GENERAL] Solution for Synonyms

2013-11-22 Thread Thomas Kellerer

mrprice22 wrote on 22.11.2013 19:25: We are in the process of moving from Oracle to PostgreSQL. We use a stored procedure to populate some reporting tables once an hour. There are two sets of these tables, set A and set B. We use synonyms to point to the “active” set of tables at any given tim

[GENERAL] Solution for Synonyms

2013-11-22 Thread mrprice22

We are in the process of moving from Oracle to PostgreSQL. We use a stored procedure to populate some reporting tables once an hour. There are two sets of these tables, set A and set B. We use synonyms to point to the “active” set of tables at any given time. The procedure works like this: 1