Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore
Дата
Msg-id 34d269d40803061240r41f91fe8x901dc9435414f9b6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
<snip>

>  It seems much more restrictive than necessary, plus it does nothing
>  for the check-constraint case.  My recollection of the previous
>  discussion about how to fix this was that we needed to add an inhcount
>  column to pg_constraint, and add entries for not-null constraints (at
>  least inherited ones) to pg_constraint so that they'd be able to have
>  inhcount fields.  The latter would also allow us to attach names to
>  not-null constraints, which I think is required by spec but we've never
>  supported.
>
>                         regards, tom lane
>

Ok I found some time to look at what would be involved in that...
Seems doable.  Ill see what I can whip up in the next month.  (Im time
pressed, who isn't though) Ill just post whatever i come up with (if
and when) to psql-patches.

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

Предыдущее
От: "Samuel Gilbert"
Дата:
Сообщение: BUG #4016: Build fails in ecpglib on file extern.h
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_dump produces invalid SQL for "group by cast(null as numeric)"