insert woes - Mailing list pgsql-general

From tony
Subject insert woes
Date
Msg-id 1112688948.19734.15.camel@hush
Whole thread Raw
Responses Re: insert woes  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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

Please slap me around the head to set my ideas straight again =:-D

Tony


pgsql-general by date:

Previous
From: Russell Smith
Date:
Subject: Re: [HACKERS] plPHP in core?
Next
From: Richard Huxton
Date:
Subject: Re: insert woes