← Back to team overview

launchpad-dev team mailing list archive

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