Re: pg_dump and DEFAULT column values

Поиск
Список
Период
Сортировка
Искать
От
Eric Ridge
Тема
Re: pg_dump and DEFAULT column values
Дата
Msg-id
D3ADE25911614840BC69C72E3171E4ED028130@tcdiexch.tcdi.com
Список
Дерево обсуждения
Re: pg_dump and DEFAULT column values "Eric Ridge" <ebr@tcdi.com>
Re: pg_dump and DEFAULT column values Tom Lane <tgl@sss.pgh.pa.us>
> pg_dump has a hard time with circular dependencies :-(

but on the plus side, pg_dump is really fast!  much faster than dump
utilities of other databases I've seen.
 
> Have you considered using a sequence, rather than generating 
> new values
> as shown above?  The approach you are using is extremely fragile:
> consider what happens if two backends try to insert at the same time.

a sequence it is!  thanks.

eric
В списке pgsql-general по дате отправления
От: jd@commandprompt.com (Joshua Drake)
Дата:
От: Eric Ridge
Дата:
FAQ