-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
After sitting on it for a while I see now that hackers emeritus really
doesn't belong above major contributor. Please apply:
BEGIN;
SELECT type,typename,sortorder FROM developers_types;
UPDATE developers_types SET sortorder = 1 WHERE type = 1;
UPDATE developers_types SET sortorder = 2 WHERE type = 3;
UPDATE developers_types SET sortorder = 4 WHERE type = 2;
UPDATE developers_types SET sortorder = 3 WHERE type = 4;
UPDATE developers_types SET sortorder = 5 WHERE type = 5;
SELECT type,typename,sortorder FROM developers_types ORDER BY sortorder;
COMMIT;
Which should give you:
type | typename | sortorder
- ------+--------------------+----------- 1 | Core Team | 1 3 | Major Contributors | 2 4
|Minor Contributors | 3 2 | Hackers Emeritus | 4 5 | Past Contributors | 5
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHkVFOATb/zqfZUUQRAuYwAJ4+I2tB2adOlaQqAJzNMprBCdJj0ACdHRjY
dLx9xa1mBwswo8tXbZSPakQ=
=OabS
-----END PGP SIGNATURE-----