Ryan Bradetich wrote:
>
> I've finished that patch for the serial->sequences but I am not happy with it.
>
> I don't think belive my proposed idea is the correct approach. I still want to work on this
> idea, but I'm not sure how to proceed.
>
> Here are my thoughts:
>
> 1. If I use my proposed idea, everything works great until you dump/reload the table. The dump
> doesn't store the data type as serial, but as int with a default and a sequence. So when the
> table gets reloaded, the relationship nolonger exists. (I think I finally understand the dump
> issues now Tom :))
Add attnum - attribute number of SERIAL column in table -
to new relation: using this pg_dump will know what
columns are SERIAL ones and what are not...
Vadim