| From: | "Alex Hunsaker" <badalex(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [PATCHES] BUG #3973: pg_dump using inherited tables do not always restore |
| Date: | 2008-03-06 20:40:02 |
| Message-ID: | 34d269d40803061240r41f91fe8x901dc9435414f9b6@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
<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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2008-03-06 21:29:51 | Re: pg_dump produces invalid SQL for "group by cast(null as numeric)" |
| Previous Message | Samuel Gilbert | 2008-03-06 20:01:49 | BUG #4016: Build fails in ecpglib on file extern.h |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2008-03-06 20:44:47 | Re: CopyReadLineText optimization |
| Previous Message | Greg Smith | 2008-03-06 20:29:18 | Re: CopyReadLineText optimization |