Does changing attribute order breaks something? - Mailing list pgsql-hackers

From geohas
Subject Does changing attribute order breaks something?
Date
Msg-id 53B1924C.6040508@hasibether.at
Whole thread Raw
Responses Re: Does changing attribute order breaks something?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

Are there any known issues when changing the attnums?

like :

airport=# update pg_attribute set attnum = 3 where attname = 'abc' and
attrelid = 18328;
UPDATE 1
airport=# update pg_attribute set attnum = 2 where attname = 'foo' and
attrelid = 18328;
UPDATE 1

Does something break or are there any other ideas to change the order of
columns?

regard

geohas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJTsZJMAAoJEJFGMlQe7wR/WL4H/32LaOBR5jKL4kvmCNKeItIF
g8EFPf4gJS9SleX0n6m7ctuKUkGQTkD6Ae7Azv0YyiMzJATgXlMHFUojj2JdyGar
yvPF2pxEzTwLPkST0cOuC68k/6KxZBvpy5FBaSFNAI1mExOTyNpO8H7lk6zWxw34
Iw8IWdayBqStdZ4HVMVTp6Vq6ReWpRKf/ekcbTIp9EKpimz0RsLafO3b0J1epv6t
w5VHCMLMuE8QtKuYaGkQ1+OwgKUiZQT/8vp4F4c5DIIYqpWWa4JjoNVmOA0leaVm
I1IFhNlo59jnPIRNR5/mIzezeA2LxZhuY4EOX6+zLy3iuja7KbdO6wXt1zedWBY=
=0KWv
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: delta relations in AFTER triggers
Next
From: Robert Haas
Date:
Subject: Re: Spinlocks and compiler/memory barriers