Обсуждение: Does changing attribute order breaks something?
-----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-----
geohas <lists@hasibether.at> writes: > Are there any known issues when changing the attnums? > 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 I assume you quickly found out that that totally broke your table, so why are you asking? regards, tom lane