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