Version bump to 7.3.19 for bug #175791 (CVE-2007-2138 privilege escalation in SECURITY DEFINER functions).

Package-Manager: portage-2.1.2.2

5 files changed, 323 insertions, 5 deletions

diff --git a/dev-db/postgresql/ChangeLog b/dev-db/postgresql/ChangeLog
index fa1b9af4d7b7..52c97fc2b1f5 100644
--- a/dev-db/postgresql/ChangeLog
+++ b/dev-db/postgresql/ChangeLog
@@ -1,6 +1,13 @@
 # ChangeLog for dev-db/postgresql
 # Copyright 2002-2007 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/ChangeLog,v 1.334 2007/05/02 08:50:01 voxus Exp $
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/ChangeLog,v 1.335 2007/05/03 04:41:52 aross Exp $
+
+*postgresql-7.3.19 (03 May 2007)
+
+  03 May 2007; Andrew Ross <aross@gentoo.org>
+  +files/postgresql-7.3.19-cubeparse.patch, +postgresql-7.3.19.ebuild:
+  Version bump to 7.3.19 for bug #175791 (CVE-2007-2138 privilege escalation
+  in SECURITY DEFINER functions).
 
 *postgresql-8.2.4-r1 (02 May 2007)
 
diff --git a/dev-db/postgresql/Manifest b/dev-db/postgresql/Manifest
index 509e1c944943..2f3e76476aee 100644
--- a/dev-db/postgresql/Manifest
+++ b/dev-db/postgresql/Manifest
@@ -38,6 +38,10 @@ AUX postgresql-7.3.18-gentoo.patch 2253 RMD160 c8ecc1797c7aefd94363cb4479bea1cc3
 MD5 d50cead2635608aa6893178d8c4ac8da files/postgresql-7.3.18-gentoo.patch 2253
 RMD160 c8ecc1797c7aefd94363cb4479bea1cc345fb622 files/postgresql-7.3.18-gentoo.patch 2253
 SHA256 801bc08232ea7cdaca8bd0179f28db6bb207702b2b394c895f6fccaff5402b8a files/postgresql-7.3.18-gentoo.patch 2253
+AUX postgresql-7.3.19-cubeparse.patch 1296 RMD160 9b9c0fcf4d58fb989ae77d9ada4588b1876400a6 SHA1 c128746e9938d7aaa4f2be6521530d07c7e207a8 SHA256 1844950b55509b83f38bfdd113350df7422f96ca4c773def6d38ca2f48fcfada
+MD5 5d36c9cda475e2aaf9609655dfb44ac1 files/postgresql-7.3.19-cubeparse.patch 1296
+RMD160 9b9c0fcf4d58fb989ae77d9ada4588b1876400a6 files/postgresql-7.3.19-cubeparse.patch 1296
+SHA256 1844950b55509b83f38bfdd113350df7422f96ca4c773def6d38ca2f48fcfada files/postgresql-7.3.19-cubeparse.patch 1296
 AUX postgresql-7.4-gentoo.patch 1741 RMD160 202f7c21d984a45a1adec0ac92ae727bd75535c6 SHA1 205293bd138db9948220cbcdc401f202eb9814a5 SHA256 9bd9fefdb9d5d8a62ec00c8ac0175322ae66ca860c3571593fea81ffd4add8dc
 MD5 048439fadb678ce304dec9629829bcc2 files/postgresql-7.4-gentoo.patch 1741
 RMD160 202f7c21d984a45a1adec0ac92ae727bd75535c6 files/postgresql-7.4-gentoo.patch 1741
@@ -199,6 +203,7 @@ DIST hier-Pg8.0.1-0.5.4.diff.gz 30662 RMD160 f212f840d06a914fd668398848baef5a269
 DIST postgresql-base-7.3.15.tar.bz2 5695061 RMD160 55cc363e1ce26ea0c7f79c5adfd90714988afb46 SHA1 059f16d3e98df525e9c0962f29f2126a9397dc02 SHA256 81da1ab6c3d9e19aef068cc1db81ca696771dfa5c8ff262bcb1bf977ac7429dc
 DIST postgresql-base-7.3.16.tar.bz2 5696231 RMD160 aaf7e4743bc67c0a45d8d44cef840283e7ead6f9 SHA1 cc01fecb6d419b6f4d9f2c4f683ee6e066382640 SHA256 96046fc13596e4d9f7a4dcd5882fed51ec5905760cc828594443272a69c140e5
 DIST postgresql-base-7.3.18.tar.bz2 5695073 RMD160 62607d50fbf97ae0b954943e2e27052bcf2c5aa0 SHA1 29e2121ee6383929e8b90b50e8f7bbac218f203e SHA256 648c7bddcab5477c5d7800795f8392a3ecdd361828c4374d9804bfa61a07b048
+DIST postgresql-base-7.3.19.tar.bz2 5691127 RMD160 802bbba70d1368097a74de6b67589ab9645597cc SHA1 09206cd4d9c2b5648756eff70f101cec89365776 SHA256 1804e0424e4444f67acfb98b4e4ad2ede26748d1ddb4a9201cbff7627e394e6a
 DIST postgresql-base-7.4.13.tar.bz2 6576973 RMD160 5f90ed85fdceb06fe15e324620e931140e3617ef SHA1 cb326a788833e805a54a80d87aeeb6fa00fb7b1e SHA256 2e2fa6b1cf3fc7a66a58762acfb64ce42d358e0dd799a467316e937d3a116cf7
 DIST postgresql-base-7.4.14.tar.bz2 6575201 RMD160 c5b8ecd20ad2783c3f254f0e7402aab9ad722d0a SHA1 b737a35070bf13f478e8bca346a32243b9599b89 SHA256 5a34fcd56d2d8eebcd2728e5971c0d39d2971dc25e49d88bfeb84d69b5e8ebc9
 DIST postgresql-base-7.4.16.tar.bz2 6586435 RMD160 8536d5f6f26a101240c64084e6adeb260efef891 SHA1 d3f36c6ace31d3725828aa9d86f4c08f266e33e3 SHA256 d8e7df2f06f248e66023452fa9cf565640b93ae43433dade7515f54e643f5c21
@@ -212,6 +217,7 @@ DIST postgresql-base-8.2.4.tar.bz2 8549159 RMD160 876105c3cc9d36b66cf9dc9b687d4b
 DIST postgresql-docs-7.3.15.tar.bz2 2361345 RMD160 7330f8f5e3d4061e28ec4fb28939011ae5038551 SHA1 3740ab265033d1827fd8e06eb0257b0275cd4ce4 SHA256 832239ebdef5501a8b32f3d2b2f1684c2e9c18fa6cec0370e950b20a62f07cf9
 DIST postgresql-docs-7.3.16.tar.bz2 2361886 RMD160 ae36bf748e8a8a0b4842ddab48c2d8a2471b2940 SHA1 09fdc7b582595fa7aea62e1888d64a741e2192cb SHA256 2d8cc0d745a3f8edd773a06c462f98c143388060feb1775e97ecf85bb5260b2f
 DIST postgresql-docs-7.3.18.tar.bz2 2363625 RMD160 5c95e654b7029f1d6289987ad0a08266ab6e54fa SHA1 0165ca2c16d3095fbc96a2fa5dd1800bd163071a SHA256 24f509b444dc1a9009ffdb6a8e484f038762b971cea60fb9bdc8943fd6a0fa55
+DIST postgresql-docs-7.3.19.tar.bz2 2365906 RMD160 acad805217a5b16badc5ea1c5f88e2780d48e849 SHA1 3af665fdbd6f0ac2b1d1563944401b5e470f25c1 SHA256 0a4910cf776b6be8017eaf68a60c541be59288079fe5696d955bdace22ebde0a
 DIST postgresql-docs-7.4.13.tar.bz2 2426721 RMD160 4500c150a1638279394bf6f6882682f019ddf8ae SHA1 60c145ec822fca74cab03f3e11918df22752f899 SHA256 31d91342f23dc842839ee9f5b7475582a2e232c6831c6d514c3a414ed28ebdf8
 DIST postgresql-docs-7.4.14.tar.bz2 2427724 RMD160 dd67ae2c4552986ced80d1ba52df50a5ae63db9b SHA1 47296643429237d81a0565aac819ded106cca36b SHA256 6739dcb6876e1f76933f88feae0b7d0a5e528e9677dac4175e3223ef379ed789
 DIST postgresql-docs-7.4.16.tar.bz2 2429657 RMD160 f6b50b3b7c1c5bad00b9a33694eef46634bd95f1 SHA1 4b49280188e269d87579004795c7063b58797cbc SHA256 7478f43e5071756434526259895f16ffeffa4c8a11dbd9af2df34250a7f463be
@@ -225,6 +231,7 @@ DIST postgresql-docs-8.2.4.tar.bz2 2769630 RMD160 bcdb176f509f69141524ababa0f6c9
 DIST postgresql-opt-7.3.15.tar.bz2 341753 RMD160 8057276fff0ae87f49fb4853e6f3df681de405b9 SHA1 300ed5f2193367d5800c2fd1bdcab2e1764a2372 SHA256 9b513f3bdd2d63579698ecc9226866ca72fe2e13fd9f0367a07c5041dd8386f6
 DIST postgresql-opt-7.3.16.tar.bz2 341908 RMD160 00e0f059910eed3021ba5b096e86bdc6878c34d6 SHA1 aac3126d50dfb1ea23984ecdff9cc6da7605b531 SHA256 0e1ab00b1439c5930b6c74ed5c4382c01fdb54434857ac3c1599d32fcce2c8d1
 DIST postgresql-opt-7.3.18.tar.bz2 342315 RMD160 fa7cb704ff7bb131f6108217c645821413ecd5b8 SHA1 5c1a8a103d696668abae7d8931c0dd687cdb7766 SHA256 6d422a3d4d56192952c035d01aff59b90c7ab7b3cdb7f300572e40dd20db5e4b
+DIST postgresql-opt-7.3.19.tar.bz2 342076 RMD160 7ee1dea5c906d88ba3384ea805368a9dcb8af47d SHA1 0736e5056f1428fc542853975e7fbd1b383f568c SHA256 2735bceed9f0d27befb3ec26b5d76f9272da1cdf2434ceb9d68327494912017f
 DIST postgresql-opt-7.4.13.tar.bz2 333860 RMD160 9fd1caacd6d842a473725450a0973173f68ae7b8 SHA1 79455e60f074a488ab3abafd10bfce4c63b33293 SHA256 8139a7161b2a55eba304b027896f0bfc81523dd41f7d1df222274b7a55e5aeab
 DIST postgresql-opt-7.4.14.tar.bz2 333417 RMD160 a6279f5b9d52f72ce786bc468c114befb5a1f29a SHA1 becc575260128261dc7f8ed46f166f54f48b8732 SHA256 e670d22812c50512807edd692d867e2b62c6b79f9d7b84cad56ef038cc12475d
 DIST postgresql-opt-7.4.16.tar.bz2 333683 RMD160 fec0e9b68c4868f4e2b85c002103089fbdbedf6f SHA1 657fe7c4ae1ba3020de4594117a1ab5db45f61bc SHA256 13a3063570c27ecc8ae163c86439b3c0b95d21bd55cac2506b105a486d410469
@@ -237,6 +244,7 @@ DIST postgresql-opt-8.1.8.tar.bz2 144643 RMD160 2a31e70be662ee6753bcc8e712ea5a69
 DIST postgresql-opt-8.2.4.tar.bz2 167612 RMD160 aaacb743be86afbfe0f885b7994c15c94fef2413 SHA1 892112c6f348bccce534f87336ea073a0b8ca249 SHA256 5977ca1f0913aa98bc889e49b38768621865959b14e2674e7716d44b7fe9eb35
 DIST postgresql-test-7.3.16.tar.bz2 891104 RMD160 7510ed474d4c86610c14c232cf5be13c4ca0b32b SHA1 c79aec31949e54700c45ac436b4844bc8bf5ee4e SHA256 5844984770b326cfc62580d88f878196e304867fa339925fef20c017bb298d56
 DIST postgresql-test-7.3.18.tar.bz2 891032 RMD160 f18fa7025a37bf85936ba78f5cdbb4e26e0a9bfb SHA1 f9488d5c113083563b652e9d4d9c4f4918892aa3 SHA256 61bf71f0b09fa0a0dc667f636fe7a338f33d7b337159b16820a0a6240318a48e
+DIST postgresql-test-7.3.19.tar.bz2 891109 RMD160 4f5ee0f9c4dd86b6ee54a818e25e929c2fc2334f SHA1 7d40accb365cc41091a6fd62d08e2e8d57121678 SHA256 8df80f3fb5f61d61fe6348e037c614b3c0f2114ae5c8a7f3050b5fadde517ba3
 DIST postgresql-test-7.4.14.tar.bz2 902074 RMD160 c6e1f57c77815b5395882cd482ef8bc952adabbf SHA1 3b15dbebe4232f66a253ff03729ee4ec3ffbd877 SHA256 39c87c0227f8c757d29141bb8c24e2a95d3a06d9bc459667fdee4d0028d6d12d
 DIST postgresql-test-7.4.16.tar.bz2 901854 RMD160 37a1ca493bd35534636dd82c1dd2468c4e37cf6c SHA1 565cfcfce7aae3e09ed1ecf0d7bc573ec0d31f96 SHA256 851d5de0f66e3a13a57acffc50f15288a2d367160902e08d0bd1a0deb72b0f39
 DIST postgresql-test-8.0.12.tar.bz2 931028 RMD160 e8527c571f727c14eedc8551cce75f6565d516af SHA1 31046252ff7e9cfde68e14f623d054342c9150ad SHA256 54da2084d7ac970155836b5cf1d278b357df8a67d2a5af101f3390f866de18ac
@@ -257,6 +265,10 @@ EBUILD postgresql-7.3.18.ebuild 8012 RMD160 8af87aefe00b779620028ff768635156032e
 MD5 6c5168bc2531899b312fd4d5df17dc72 postgresql-7.3.18.ebuild 8012
 RMD160 8af87aefe00b779620028ff768635156032e93c4 postgresql-7.3.18.ebuild 8012
 SHA256 11eb44699e94605dc373a7d0d443b716b7dc3e7bddd2d1f0835fbe3c8ac8e52f postgresql-7.3.18.ebuild 8012
+EBUILD postgresql-7.3.19.ebuild 8310 RMD160 d030d985ba3ae6086163c7c1ce3941916d8a2c2e SHA1 a3d86520b44c58d2c2164948a3efc899ec78ae11 SHA256 5118887c69e6edf9c863a5ab4f7560f270494cc3c55b35f0396c6dff865ae0be
+MD5 642190b8ed1225e7615c14efd72fc929 postgresql-7.3.19.ebuild 8310
+RMD160 d030d985ba3ae6086163c7c1ce3941916d8a2c2e postgresql-7.3.19.ebuild 8310
+SHA256 5118887c69e6edf9c863a5ab4f7560f270494cc3c55b35f0396c6dff865ae0be postgresql-7.3.19.ebuild 8310
 EBUILD postgresql-7.4.13.ebuild 10668 RMD160 fbfdce1b60a58b17caef9ad3edf32196b12deb93 SHA1 7365944c059457676c56c99e5b497d336614f5ed SHA256 7c02449245b17efcf7b5b3bc653c0006b6b34ef0b578b1eeec57dd4a3c8c10c6
 MD5 28765b29513951793584774adbb1d8e2 postgresql-7.4.13.ebuild 10668
 RMD160 fbfdce1b60a58b17caef9ad3edf32196b12deb93 postgresql-7.4.13.ebuild 10668
@@ -297,10 +309,10 @@ EBUILD postgresql-8.2.4-r1.ebuild 8378 RMD160 3b85064651af77c027aafde014d22d624d
 MD5 d1e75740d203ed4a5f55aa5c2a363a30 postgresql-8.2.4-r1.ebuild 8378
 RMD160 3b85064651af77c027aafde014d22d624df222ee postgresql-8.2.4-r1.ebuild 8378
 SHA256 30b8f49a2d4ea8f03478fc85c8db3732dc03adb9b01fe76b9df4495fa2163938 postgresql-8.2.4-r1.ebuild 8378
-MISC ChangeLog 70452 RMD160 15a92bdff7478b899173e18ca5e8fdb723465e6f SHA1 7071e2cab319165dd1ef68851bd04724f11bf7a4 SHA256 8bd16b0fa1a550526e5bf04bbade21de6d7ded84f147ad710dca85f929b1fe6e
-MD5 a8cf15a4181595e67be2c539191cb280 ChangeLog 70452
-RMD160 15a92bdff7478b899173e18ca5e8fdb723465e6f ChangeLog 70452
-SHA256 8bd16b0fa1a550526e5bf04bbade21de6d7ded84f147ad710dca85f929b1fe6e ChangeLog 70452
+MISC ChangeLog 70715 RMD160 b6d08601cc80933300e76e3aed7463df6012869f SHA1 043bdc850999e9c2d97687757fa9be1833cbe43d SHA256 b08fda87451d5fa33e5e3ea0310c60b08f5c4493ea1685741f8698da2d9b472e
+MD5 5d308cf59aae1738d7dce59832c3aebb ChangeLog 70715
+RMD160 b6d08601cc80933300e76e3aed7463df6012869f ChangeLog 70715
+SHA256 b08fda87451d5fa33e5e3ea0310c60b08f5c4493ea1685741f8698da2d9b472e ChangeLog 70715
 MISC metadata.xml 164 RMD160 becfe652663bd65719dd11fa6ffb588b3d5b4ecc SHA1 f67b7ac1c5e6e65ef5a19a589d4759c84918f86c SHA256 7e8e8126bc8701c4a42c7dfed8bb755ac6040fe3d0e3f994d888f8b2b4fa7d8b
 MD5 6fe52df942ef15801d56449cd8299604 metadata.xml 164
 RMD160 becfe652663bd65719dd11fa6ffb588b3d5b4ecc metadata.xml 164
@@ -314,6 +326,9 @@ SHA256 f7e827953703308dcf63a803c828370b879f5a7a8f8bb44ff4fbc7e663095000 files/di
 MD5 aa806bfc274dd6877289ae8f0ba5f390 files/digest-postgresql-7.3.18 1087
 RMD160 f1269a2b0a808eaec3530694cf8fcc99d7dbc702 files/digest-postgresql-7.3.18 1087
 SHA256 bdb45b470c38cbd25b7c2659ac2bc3eb1d50c1856a8b1f3d7344e25d7a9be1a7 files/digest-postgresql-7.3.18 1087
+MD5 0bff8b5391e9dbfa8b6a919a0d524a37 files/digest-postgresql-7.3.19 1087
+RMD160 1bb8544863cd2c6d2fa317d55e1ecfb230547f1c files/digest-postgresql-7.3.19 1087
+SHA256 59079fe9d80de56c7e6eef5e64f106bbf5143462d9472953a192e33a4b6201b7 files/digest-postgresql-7.3.19 1087
 MD5 5785510b983e3724b1e7be4045bb5ef9 files/digest-postgresql-7.4.13 1063
 RMD160 cacfc7cab610de62e3ee63e3da217d54c1a7c357 files/digest-postgresql-7.4.13 1063
 SHA256 d4f40c91569847681ebd3254bf787f393f893c0e05b603d52eeb28e40d4fc2c4 files/digest-postgresql-7.4.13 1063
diff --git a/dev-db/postgresql/files/digest-postgresql-7.3.19 b/dev-db/postgresql/files/digest-postgresql-7.3.19
new file mode 100644
index 000000000000..770e85467eac
--- /dev/null
+++ b/dev-db/postgresql/files/digest-postgresql-7.3.19
@@ -0,0 +1,12 @@
+MD5 b9b2dca0468bafff72486bd54812c317 postgresql-base-7.3.19.tar.bz2 5691127
+RMD160 802bbba70d1368097a74de6b67589ab9645597cc postgresql-base-7.3.19.tar.bz2 5691127
+SHA256 1804e0424e4444f67acfb98b4e4ad2ede26748d1ddb4a9201cbff7627e394e6a postgresql-base-7.3.19.tar.bz2 5691127
+MD5 de4888125bef49f9f53824d4f9ae7bf6 postgresql-docs-7.3.19.tar.bz2 2365906
+RMD160 acad805217a5b16badc5ea1c5f88e2780d48e849 postgresql-docs-7.3.19.tar.bz2 2365906
+SHA256 0a4910cf776b6be8017eaf68a60c541be59288079fe5696d955bdace22ebde0a postgresql-docs-7.3.19.tar.bz2 2365906
+MD5 1fe88fa959492155518787c0eb197b14 postgresql-opt-7.3.19.tar.bz2 342076
+RMD160 7ee1dea5c906d88ba3384ea805368a9dcb8af47d postgresql-opt-7.3.19.tar.bz2 342076
+SHA256 2735bceed9f0d27befb3ec26b5d76f9272da1cdf2434ceb9d68327494912017f postgresql-opt-7.3.19.tar.bz2 342076
+MD5 a0958b2352586b7cd4083f46e1ba1ae8 postgresql-test-7.3.19.tar.bz2 891109
+RMD160 4f5ee0f9c4dd86b6ee54a818e25e929c2fc2334f postgresql-test-7.3.19.tar.bz2 891109
+SHA256 8df80f3fb5f61d61fe6348e037c614b3c0f2114ae5c8a7f3050b5fadde517ba3 postgresql-test-7.3.19.tar.bz2 891109
diff --git a/dev-db/postgresql/files/postgresql-7.3.19-cubeparse.patch b/dev-db/postgresql/files/postgresql-7.3.19-cubeparse.patch
new file mode 100644
index 000000000000..705e073c8e45
--- /dev/null
+++ b/dev-db/postgresql/files/postgresql-7.3.19-cubeparse.patch
@@ -0,0 +1,36 @@
+--- contrib/cube/cubescan.l.orig	2006-07-05 06:56:04.000000000 +0000
++++ contrib/cube/cubescan.l	2006-07-05 06:56:12.000000000 +0000
+@@ -9,6 +9,10 @@
+ 
+ 
+ /* flex screws a couple symbols when used with the -P option; fix those */
++#ifndef YY_PROTO
++#define YY_PROTO(proto) proto
++#endif
++
+ #define YY_DECL int cube_yylex YY_PROTO(( void )); \
+ int cube_yylex YY_PROTO(( void ))
+ #define yylval cube_yylval
+--- contrib/seg/segscan.l.orig	2006-07-05 07:08:26.000000000 +0000
++++ contrib/seg/segscan.l	2006-07-05 07:08:51.000000000 +0000
+@@ -9,6 +9,10 @@
+ 
+ 
+ /* flex screws a couple symbols when used with the -P option; fix those */
++#ifndef YY_PROTO
++#define YY_PROTO(proto) proto
++#endif
++
+ #define YY_DECL int seg_yylex YY_PROTO(( void )); \
+ int seg_yylex YY_PROTO(( void ))
+ #define yylval seg_yylval
+--- contrib/tsearch/parser.l.orig	2006-07-05 07:22:36.000000000 +0000
++++ contrib/tsearch/parser.l	2006-07-05 07:23:33.000000000 +0000
+@@ -18,6 +18,7 @@
+ char *s     = NULL;  /* to return WHOLE hyphenated-word */
+ 
+ YY_BUFFER_STATE buf = NULL; /* buffer to parse; it need for parse from string */
++static YY_BUFFER_STATE yy_current_buffer = 0;
+ 
+ int lrlimit = -1;	/* for limiting read from filehandle ( -1 - unlimited read ) */
+ int bytestoread = 0;	/* for limiting read from filehandle */
diff --git a/dev-db/postgresql/postgresql-7.3.19.ebuild b/dev-db/postgresql/postgresql-7.3.19.ebuild
new file mode 100644
index 000000000000..c78e39865e8c
--- /dev/null
+++ b/dev-db/postgresql/postgresql-7.3.19.ebuild
@@ -0,0 +1,248 @@
+# Copyright 1999-2007 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/postgresql-7.3.19.ebuild,v 1.1 2007/05/03 04:41:52 aross Exp $
+
+inherit eutils gnuconfig flag-o-matic multilib toolchain-funcs versionator
+
+KEYWORDS="~alpha ~amd64 ~arm ~hppa ~ia64 ~mips ~ppc ~ppc64 ~s390 ~sh ~sparc ~x86"
+
+DESCRIPTION="Sophisticated and powerful Object-Relational DBMS."
+HOMEPAGE="http://www.postgresql.org/"
+SRC_URI="mirror://postgresql/source/v${PV}/${PN}-base-${PV}.tar.bz2
+		mirror://postgresql/source/v${PV}/${PN}-opt-${PV}.tar.bz2
+		doc? ( mirror://postgresql/source/v${PV}/${PN}-docs-${PV}.tar.bz2 )
+		test? ( mirror://postgresql/source/v${PV}/${PN}-test-${PV}.tar.bz2 )"
+LICENSE="POSTGRESQL"
+SLOT="0"
+IUSE="doc kerberos nls pam perl pg-intdatetime python readline selinux ssl tcl test xml zlib"
+
+RDEPEND="~dev-db/libpq-${PV}
+		>=sys-libs/ncurses-5.2
+		kerberos? ( virtual/krb5 )
+		pam? ( virtual/pam )
+		perl? ( >=dev-lang/perl-5.6.1-r2 )
+		python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
+		readline? ( >=sys-libs/readline-4.1 )
+		selinux? ( sec-policy/selinux-postgresql )
+		ssl? ( >=dev-libs/openssl-0.9.6-r1 )
+		tcl? ( >=dev-lang/tcl-8 )
+		xml? ( dev-libs/libxml2 dev-libs/libxslt )
+		zlib? ( >=sys-libs/zlib-1.1.3 )"
+DEPEND="${RDEPEND}
+		sys-devel/autoconf
+		>=sys-devel/bison-1.875
+		nls? ( sys-devel/gettext )
+		xml? ( dev-util/pkgconfig )"
+
+PG_DIR="/var/lib/postgresql"
+[[ -z "${PG_MAX_CONNECTIONS}" ]] && PG_MAX_CONNECTIONS="512"
+
+pkg_setup() {
+	if [[ -f "${PG_DIR}/data/PG_VERSION" ]] ; then
+		if [[ $(cat "${PG_DIR}/data/PG_VERSION") != $(get_version_component_range 1-2) ]] ; then
+			eerror "PostgreSQL ${PV} cannot upgrade your existing databases, you must"
+			eerror "use pg_dump to export your existing databases to a file, and then"
+			eerror "pg_restore to import them when you have upgraded completely."
+			eerror "You must remove your entire database directory to continue."
+			eerror "(database directory = ${PG_DIR})."
+			die "Remove your database directory to continue"
+		fi
+	fi
+	enewgroup postgres 70
+	enewuser postgres 70 /bin/bash /var/lib postgres
+}
+
+src_unpack() {
+	unpack ${A}
+	cd "${S}"
+
+	sed -i -e '/for pgac_lib in "" " -ltermcap"/ s/" -ltermcap"//' configure
+
+	# libpq is provided separately as dev-db/libpq
+	sed -i -e 's/^DIRS := libpq ecpg/DIRS := ecpg/' src/interfaces/Makefile
+	sed -i -e '/\W\+\$.MAKE. -C include \$/d' src/Makefile
+	sed -i -e '/^\W\+psql scripts pg_config pg_controldata/ s/pg_config //' src/bin/Makefile
+
+	epatch "${FILESDIR}/${P}-cubeparse.patch"
+
+	# Prepare package for future tests
+	if use test ; then
+		# We need to run the tests as a non-root user, portage seems the most fitting here,
+		# so if userpriv is enabled, we use it directly. If userpriv is disabled, well, we
+		# don't support that in this version of PostgreSQL ... :)
+		mkdir -p "${S}/src/test/regress/tmp_check"
+		chown portage "${S}/src/test/regress/tmp_check"
+		einfo "Tests will be run as user portage."
+	fi
+}
+
+src_compile() {
+	filter-flags -ffast-math -feliminate-dwarf2-dups
+
+	# Correctly support the XML stuff
+	if use xml ; then
+		CFLAGS="${CFLAGS} $(pkg-config --cflags libxml-2.0)"
+		LIBS="${LIBS} $(pkg-config --libs libxml-2.0)"
+	fi
+
+	# Detect mips systems properly
+	gnuconfig_update
+
+	cd "${S}"
+
+	./configure --prefix=/usr \
+		--includedir=/usr/include/postgresql/pgsql \
+		--sysconfdir=/etc/postgresql \
+		--mandir=/usr/share/man \
+		--host=${CHOST} \
+		--docdir=/usr/share/doc/${PF} \
+		--libdir=/usr/$(get_libdir) \
+		--enable-depend \
+		$(use_with kerberos krb5) \
+		$(use_enable nls ) \
+		$(use_with pam) \
+		$(use_with perl) \
+		$(use_enable pg-intdatetime integer-datetimes ) \
+		$(use_with python) \
+		$(use_with readline) \
+		$(use_with ssl openssl) \
+		$(use_with tcl) \
+		--without-tk \
+		$(use_with zlib) \
+		|| die "configure failed"
+
+	emake -j1 LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die "main emake failed"
+
+	cd "${S}/contrib"
+	emake -j1 LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die "contrib emake failed"
+
+	if use xml ; then
+		cd "${S}/contrib/xml"
+		emake -j1 LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die "contrib/xml emake failed"
+	fi
+}
+
+src_install() {
+	if use perl ; then
+		mv -f "${S}/src/pl/plperl/GNUmakefile" "${S}/src/pl/plperl/GNUmakefile_orig"
+		sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \
+			"${S}/src/pl/plperl/GNUmakefile_orig" > "${S}/src/pl/plperl/GNUmakefile"
+	fi
+
+	cd "${S}"
+	emake -j1 DESTDIR="${D}" LIBDIR="${D}/usr/$(get_libdir)" install || die "main emake install failed"
+
+	cd "${S}/contrib"
+	emake -j1 DESTDIR="${D}" LIBDIR="${D}/usr/$(get_libdir)" install || die "contrib emake install failed"
+
+	if use xml ; then
+		cd "${S}/contrib/xml"
+		emake -j1 DESTDIR="${D}" LIBDIR="${D}/usr/$(get_libdir)" install || die "contrib/xml emake install failed"
+	fi
+
+	cd "${S}"
+	dodoc README HISTORY
+	dodoc contrib/adddepend/*
+
+	cd "${S}/doc"
+	dodoc FAQ* README.* TODO bug.template
+
+	if use doc ; then
+		cd "${S}/doc"
+		docinto FAQ_html
+		dodoc src/FAQ/*
+		docinto sgml
+		dodoc src/sgml/*.{sgml,dsl}
+		docinto sgml/ref
+		dodoc src/sgml/ref/*.sgml
+		docinto TODO.detail
+		dodoc TODO.detail/*
+	fi
+
+	newinitd "${FILESDIR}/postgresql.init-${PV%.*}" postgresql || die "Inserting init.d-file failed"
+	newconfd "${FILESDIR}/postgresql.conf-${PV%.*}" postgresql || die "Inserting conf.d-file failed"
+}
+
+pkg_postinst() {
+	elog "Execute the following command to setup the initial database environment:"
+	elog
+	elog "emerge --config =${PF}"
+	elog
+	elog "If you need a global psqlrc-file, you can place it in '${ROOT%/}/etc/postgresql/'."
+}
+
+pkg_config() {
+	einfo "Creating the data directory ..."
+	mkdir -p "${PG_DIR}/data"
+	chown -Rf postgres:postgres "${PG_DIR}"
+	chmod 0700 "${PG_DIR}/data"
+
+	einfo "Initializing the database ..."
+	if [[ -f "${PG_DIR}/data/PG_VERSION" ]] ; then
+		eerror "PostgreSQL ${PV} cannot upgrade your existing databases."
+		eerror "You must remove your entire database directory to continue."
+		eerror "(database directory = ${PG_DIR})."
+		die "Remove your database directory to continue"
+	else
+		if use kernel_linux ; then
+			local SEM=`sysctl -n kernel.sem | cut -f-3`
+			local SEMMNI=`sysctl -n kernel.sem | cut -f4`
+			local SEMMNI_MIN=`expr \( ${PG_MAX_CONNECTIONS} + 15 \) / 16`
+			local SHMMAX=`sysctl -n kernel.shmmax`
+			local SHMMAX_MIN=`expr 500000 + 30600 \* ${PG_MAX_CONNECTIONS}`
+
+			if [ ${SEMMNI} -lt ${SEMMNI_MIN} ] ; then
+				eerror "The current value of SEMMNI is too low"
+				eerror "for PostgreSQL to run ${PG_MAX_CONNECTIONS} connections!"
+				eerror "Temporary setting this value to ${SEMMNI_MIN} while creating the initial database."
+				echo ${SEM} ${SEMMNI_MIN} > /proc/sys/kernel/sem
+			fi
+
+			su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
+
+			if [ ! `sysctl -n kernel.sem | cut -f4` -eq ${SEMMNI} ] ; then
+				echo ${SEM} ${SEMMNI} > /proc/sys/kernel/sem
+				ewarn "Restoring the SEMMNI value to the previous value."
+				ewarn "Please edit the last value of kernel.sem in /etc/sysctl.conf"
+				ewarn "and set it to at least ${SEMMNI_MIN}:"
+				ewarn
+				ewarn "  kernel.sem = ${SEM} ${SEMMNI_MIN}"
+				ewarn
+			fi
+
+			if [ ${SHMMAX} -lt ${SHMMAX_MIN} ] ; then
+				eerror "The current value of SHMMAX is too low for postgresql to run."
+				eerror "Please edit /etc/sysctl.conf and set this value to at least ${SHMMAX_MIN}:"
+				eerror
+				eerror "  kernel.shmmax = ${SHMMAX_MIN}"
+				eerror
+			fi
+		else
+			su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
+		fi
+
+		einfo
+		einfo "You can use the '${ROOT%/}/etc/init.d/postgresql' script to run PostgreSQL instead of 'pg_ctl'."
+		einfo
+	fi
+}
+
+src_test() {
+	cd "${S}"
+
+	einfo ">>> Test phase [check]: ${CATEGORY}/${PF}"
+	if hasq userpriv ${FEATURES} ; then
+		if ! emake -j1 check ; then
+			hasq test ${FEATURES} && die "Make check failed. See above for details."
+			hasq test ${FEATURES} || eerror "Make check failed. See above for details."
+		fi
+	else
+		eerror "Tests won't be run if FEATURES=userpriv is disabled!"
+	fi
+
+	einfo "Yes, there are other tests which could be run."
+	einfo "... and no, we don't plan to add/support them."
+	einfo "For now, the main regressions tests will suffice."
+	einfo "If you think other tests are necessary, please submit a"
+	einfo "bug including a patch for this ebuild to enable them."
+}