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-----
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers