insert woes

From: tony <tony(at)tgds(dot)net>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: insert woes
Date: 2005-04-05 08:15:47
Message-ID: 1112688948.19734.15.camel@hush
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-04-05 08:43:29 Re: insert woes
Previous Message Russell Smith 2005-04-05 08:06:09 Re: [HACKERS] plPHP in core?