Обсуждение: Does changing attribute order breaks something?

Поиск
Список
Период
Сортировка

Does changing attribute order breaks something?

От
geohas
Дата:
-----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-----




Re: Does changing attribute order breaks something?

От
Tom Lane
Дата:
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