| From: | mrprice22 <mrprice1(at)comcast(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Solution for Synonyms |
| Date: | 2013-11-22 18:25:04 |
| Message-ID: | 1385144704814-5779816.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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. If set A tables are “active” truncate set B tables or if set A tables are
“active” truncate set B tables.
2. Populate set B tables.
3. Set synonyms to point to set B tables.
How might I accomplish the same thing in PostgreSQL?
Thanks,
Mark
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Solution-for-Synonyms-tp5779816.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-11-22 18:32:30 | Re: pg_upgrade ?deficiency |
| Previous Message | Mike Broers | 2013-11-22 17:55:19 | Re: corruption issue after server crash - ERROR: unexpected chunk number 0 |