| From: | Sydney Puente <sydneypuente(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | drop view and recreate - for sync |
| Date: | 2009-10-23 06:45:05 |
| Message-ID: | 288984.95200.qm@web24307.mail.ird.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a requirement to pull 2 tables of data from an unreliable db and stash the data in postgres on redhat.
Dont imagine the initial load will be be too difficult, gonna use perl DBD to get the data. < 100 000 records in total , 10 -15 fields.
needs sync-ing regularly - every 12 hours maybe. Interesting feature of the data is that there is no primary key.
This data will be accessed a couple of times a second, and I have a cunning plan to have a view that points to the initial dataload, and then load up the new data into a shadow table, drop the view and then recreate it pointing to the shadow table ( which will then no longer be the shadow).
How does that sound? Good?
Syd
Send instant messages to your online friends http://uk.messenger.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kareem Sedki | 2009-10-23 08:38:27 | How to check whether a data type can be cast to another |
| Previous Message | Magnus Hagander | 2009-10-22 23:59:17 | Re: Problem calling C function in PostgreSQL |