Re: Synchronize tables question....

Don't forget to CC: the list

Jerry LeVan wrote:
>
>>> Is there an elegant way I can merge/update the two tables so that
>>> they will contain the same information ( with no duplicates or
>>> omissions)?
>>
>> It sounds like you'll want some form of replication, but whether
>> single-master or multi-master no-one can say without more information.

> I meant to say I had dblink installed :)
>
> The following sequence of steps seems to work ok, the tables are very
> small...

> insert into tmpRegistrations select *
> from dblink('select * from registrations ')
> as (software text,
> id text,
> value text,
> location text
> )
>
> select dblink_disconnect()
>
> create temp table newregistrations as
> (select * from registrations union select * from tmpregistrations )
>
> truncate table registrations
>
> insert into registrations select * from newregistrations

A couple of points:
1. What if a registration is updated?
2. What happens if you get a new registration between CREATE TEMP TABLE
and TRUNCATE?

--
Richard Huxton
Archonet Ltd