| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | Ryan Bradetich <rbrad(at)hpb50023(dot)boi(dot)hp(dot)com> |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Sequences.... |
| Date: | 1999-03-17 06:57:48 |
| Message-ID: | 36EF526C.526144AA@krs.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vadim Mikheev | 1999-03-17 07:07:36 | Re: [HACKERS] Subqueries and indexes |
| Previous Message | Bruce Momjian | 1999-03-17 05:48:17 | Re: [HACKERS] Subqueries and indexes |