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 “active” set

[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:

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