Re: insert woes

tony wrote:
> Hi,
>
> I am migrating data from one data structure to another and having
> problems writing a correct INSERT INTO blah SELECT ... from existing
> tables
>
> I have contact, my addresses (each contact can have several addresses)
> and address (each address can have several contacts).
>
> I am getting unique key address_id errors despite using a DISTINCT ON
> clause in my SELECT so I am doing something wrong

Copies of the queries in question please. Also, cut the INSERT INTO off
the front and have a look for any duplicates.

--
   Richard Huxton
   Archonet Ltd