Re: COPY enhancements

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: COPY enhancements
Дата
Msg-id alpine.GSO.2.01.0909120430040.9961@westnet.com
обсуждение исходный текст
Ответ на Re: COPY enhancements  (Emmanuel Cecchet <manu@asterdata.com>)
Ответы Re: COPY enhancements  (Emmanuel Cecchet <manu@asterdata.com>)
Список pgsql-hackers
On Fri, 11 Sep 2009, Emmanuel Cecchet wrote:

> I guess the problem with extra or missing columns is to make sure that 
> you know exactly which data belongs to which column so that you don't 
> put data in the wrong columns which is likely to happen if this is fully 
> automated.

Allowing the extra column case is easy:  everwhere in copy.c you find the 
error message "extra data after last expected column", just ignore the 
overflow fields rather than rejecting the line just based on that.  And 
the default information I mentioned you might want to substitute for 
missing columns is already being collected by the code block with the 
comment "Get default info if needed".

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: COPY enhancements
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Disable and enable of table and column constraints