insert woes

Поиск
Список
Период
Сортировка
От tony
Тема insert woes
Дата
Msg-id 1112688948.19734.15.camel@hush
обсуждение исходный текст
Ответы Re: insert woes  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: [HACKERS] plPHP in core?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: insert woes