| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jaime Casanova <systemguards(at)yahoo(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Adding columns in the middle of tables |
| Date: | 2004-09-05 03:08:41 |
| Message-ID: | 20040905110754.J6722-100000@houston.familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Given the 8.0 ALTER TABLE feature of being able to rewrite the whole
> table, one could now think about doing it without decoupling logical
> and physical numbers: just rewrite the table with the new column
> inserted in the proper place. This moves the problem to a different
> area, which is being sure you have updated every place in the system
> catalogs and backend caches that references the old column numbers of
> the renumbered columns. Again, doable in theory but a lot of work,
> and it introduces a bug hazard every time someone changes these data
> structures.
Ah, I hadn't considered the references issue. Does make it quite hard :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shahbaz Javeed | 2004-09-05 03:24:23 | Re: Developers page is down |
| Previous Message | Christopher Kings-Lynne | 2004-09-05 03:06:41 | Re: Adding columns in the middle of tables |