launchpad-dev team mailing list archive
-
launchpad-dev team
-
Mailing list archive
-
Message #01866
Re: How hard is renaming tables?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Stuart Bishop wrote:
>
>
> On Fri, Nov 27, 2009 at 5:56 PM, Jonathan Lange <jml@xxxxxxxxxxxxx> wrote:
>> How hard would it
>> be to rename Build to BinaryPackageBuild?
>>
>> It sounds nominally easy to me, but Tim said that it's now hard
>> because of replication.
> Nothing has changed because of replication. Just a DB patch as normal
> renaming the table, constraints, attached sequences etc.
I'm sure Tim got that idea from me, and I got that idea from these
review comments:
"I'm finding it is much better to drop and recreate tables than rename
them - it causes problems with index names and constraints keeping old
names and even triggered a Slony-I bug once where it was making naming
assumptions that could be broken by renaming tables."
https://code.edge.launchpad.net/~abentley/launchpad/messagejob/+merge/3610
What did I misunderstand?
Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAksP580ACgkQ0F+nu1YWqI3usgCePaKpR5VL88iOgIphQgYHgPW2
2usAnijGr5srbPsDT1+SP4s/xNVGj/WL
=723V
-----END PGP SIGNATURE-----
Follow ups
References