Received: from mailsys01.intnet.net (mailhost.wwc.com [198.252.32.15]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4IHt6A03821 for ; Fri, 18 May 2001 13:55:06 -0400 (EDT) (envelope-from joe@conway-family.com) Received: from [206.19.64.3] (HELO jecw2k1) by mailsys01.intnet.net (CommuniGate Pro SMTP 3.3.2) with SMTP id 8384177; Fri, 18 May 2001 13:54:11 -0400 Message-ID: <004e01c0dfc3$a9af5230$54d410ac@jecw2k1> From: "Joe Conway" To: "Peter Eisentraut" , "Bruce Momjian" Cc: "Jim Buttafuoco" , References: Subject: Re: Running config vars Date: Fri, 18 May 2001 10:54:59 -0700 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_004B_01C0DF88.FBB567D0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200105/738 X-Sequence-Number: 8986 This is a multi-part message in MIME format. ------=_NextPart_000_004B_01C0DF88.FBB567D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > Bruce Momjian writes: > > > I will try to get this feature into 7.2, though as backend code. > > I've long been thinking that the SET/RESET/SHOW commands could be > implemented as stored procedures and/or functions. That way you could > cleanly return the settings to the client application and compose new > values out of arbitrary expressions. If ever functions can return > multiple rows you could also arrange for them to show all current > settings. I added a function to the c library that I sent to patches the other day -- called "get_var". It implements what you describe above (that is, one variable at a time). I'd like to get this into contrib, or do the work necessary to get it into the backend -- any interest in letting me give that a try? Thanks, Joe ------=_NextPart_000_004B_01C0DF88.FBB567D0 Content-Type: application/x-compressed; name="current_db-0.2.tgz" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="current_db-0.2.tgz" H4sIACZiBDsAA+08+3PiONL7K1Tlf+jl5r7YOcIjz6pkZ+6YwGTYIySLyXxz t7dFGVsE3xjb40ey7Ffzv3/dsmUbYwhkMo+6s6oSjNQvtVqtltRGC1yXWf5I H9d/+FKl0ThqnB4f4ycv/PP05Eh8D+tODxvNxknjlJ6bzeOT5g9w/MUkSpXA 81UX4AfXtv11cBr24uT0a0j0VYuWjH/yWPM+mjXDei4eOLCN06OjVePfPDw5 iMb/6BQbEP64cYzj33guAdaV//Lxvxh0WsMOvLntXwy7131IjMBSZwwkGQad 4e2grwB93ykDtBTYvbpu3/Y6o5vW8G2/ddXZre4u4u1Cr9W/vG1ddmBX2z3f Ke+UVzOyDT3NB79uwgbBtuPyYDH3qX2Kkbdnudg5w/KPNma4ZQ+ntudnO+iz 3/1N+AncrRmquu4+lSHhbsDwjvmje5yjEtHelFOElEP+W8+476vk+//ps/J4 xP8f4bof+f/jwxN0/I3mUQNdbeH/v0Kp7+Ec2oP02FMFr3wTWJpv2JYHLvMD 1zKsO3RgExvUsR34Agd01VfHqsdivAvbmbvG3dQHSZPhZ9tjzhQrrQd1Dj/9 22Y1jT//baYaJj7PXlXhAMOAc47cMzRmaewMXittQbFO8/ZPxsTS2QQubgeD Tn84ar8evcVarDIslqklaEszA53BT57vouC16at0pebPHcbrUrUVB53Sncu8 2rSSrlY1jXlefcpUR51l2iazOzdTFfiG6dVVzcytHweG6RtWlkfY6M09TdWm LNOooYZN+67u3I28qarbD7w9DeH5tqvesbrj2toKZPwkD5/Ll3qBC2pWqBRf McgR5zTUzECh9ZlhxVJNaJyubnvD7ut/DDsZ6DGRe9CmqivgmemxUn0vwRAj Ho0twqNJ2DoO48i3R4Qq/S5DRfmlN2opF91uZQGWXL9mGmTOAg0XKGiEvCzd mOQyy6jkLlilSGSRo+YQC0XwF9XwtvWuM7rtd9+PlOuLv3eGyqJ1Bpbh+XrG OpEITcRXKYkBRV4iFYmO08nD6YhqgT3qPI4VG3n+3GTSPY6qfL4M4hsz9odt rQZos4kamP57VfO7nt1j98xcCbsRUHZEVsF5zL1n7uNwrmrp9gzBmR7D7JQx JsBADdqqH8wysax0czkSMcWoNbhUCGMFPNLbClyEh1sjbcdHRGnb4lCg9ThO FDLlAu6Uw4Wi1OK+EGaq5tperdTSdejevDsBL3Ac2/Vr3IfDUP3ALJi49gzG qobPej3yirpfR+t+sN0PNS1x7dHkNZwRieoZfzCJZpLjuzJIEn9Gg3YDzYc9 +V1r0G4NWzGEvP9qos4Mcw4vX0Lrzajb7wzhr3AEZ7DflBeoh3BPob1IZ2z4 3nZUCGORBq1A29EgjEUa90d8aLeiQhg1w7k/4rqW0/pXOoN3ncEIkUaEddV6 3+v04eD4JOOI0ostH8JvHcUU5aklP/7XnpXH+vj/4PDo5FDE/8eHtBfA+P+0 UcT/X6Msx//adxv/x4FYarNSSdamzHofizPgwnv8sAfsCfhTlsg+jsFe265r PzAdMM6/p9WEL188nhqPqNscyrDiFQ0ln2EQ4tX1sXhMlMdFTq+k3f6b69G7 prQoJK2tfPXFAOeRaGWn/H875RIFQKVSaS+EQuzSgJkqjVKp5EZPVKtoqvV3 NkfaKpS88AvVv8VNDLW1mafxelE5DByTlUo+ffAFv0RaLdGI2PaHwIHoRJBG Wgfbgqv5DUbB+6/E8Hd1Dl6PcOFCNU3mYqQwhwfDm4Jvw52rjkGFMfMx7ADT 1j4QodTuApsmtsumqMtarcaJxb2ClzQyzsh2mOVK7QhD9L6PslUhjE4U1BHr IfUwchG66Fi+O+9ahm+oJkUY/xOppQqN6vX43wyDWL3l425xHPisH8zGzK2+ GV13251f4vZL5vPhkpZ7L0fciKqQdczucKuHFZLoBTEDxVIdb2r7ffuhCs0q CEmIQsmYgPSjGKau9w6F1SUCkNEESiWGWxCpMxhcD6rpmXCG+rYs2wfOErgQ aOt/9ipVyNNVJCwfbiEt2rqFESFnhnJGICRPbCBCHo4ny0AmWXpju7NRehT1 MY7iDMlK2SYZLnHfMhzcXgwjGtTlUmRbL4FEU3xXCilw9YppUvoEtFEMWSYI t73e+Vq9iN4DaWdiB5YO+3TIDH/WUTc548h58a5zreBU5yPIh+Bc1GomurXU qOZbHk7i8LhyRMeSUjLnP+W6rfDoe9FrkaQrndYGXibaGi05mdwtDvcxqamv GDMHPWHo/tfP+KSrOGPypofodX7PxQ5quf/U8t357ljefN2u3g+GXvwaBxW9 OIfr6jdox43zlHOP8Qv/Xvj3/wT/njL0lGfXx2rWr3+XXjwzUZKbxHiuRGc5 qQkiFK8w1dWmyty7oHNdSXnbal//r/IPpduuwpLRCTXJ3Ioa0RglFrN6iFbq zbDuCTpyowZpLdR8qDjJsHwZYr6J0pJOJouyFA93eAq9PNjy/qvAY1Zif2iS DJUU9z+2ieXFccGlPrJS5K2TooPf2yqxav1ddfy3doUoFoNiMSgWg+9hMYhi 4mXPn7i1bn94eCClneunFU5NHOwveTVqWBP8rnBpY8OqO95Hk64DZ46fPmlf cym13pcJEXOd2eqLidCbRefRBIYIpb2pk9q64RKEnq7EXDcTB0+J5K8Hxye/ USXle1BwzGtH9C0xWTTmWATeXqVTa5kuBBqR3fKZJnHGEfR4nsDLwrwjMZrc Uj9lDTJp+xTzpsofsTYikIiHoFxR6EaG+PVGahsu+hVxqkYus8lzWgw0tguF X1PHLkdIlZ0TC+Qf3/y+FTlBNFPUe9Uw1bHJKqkJkZjrsPN+OLqREg6xxYY3 tOuuIL+o7eB81MKbvw1NAs1NU31hCZV8JfyrEarh+QdsY60+erO7wlXQxU2+ q6AWup/7HrwFv15aNeL5V5LP5y3EVnrKE9QS9NhkqD47jyIkf+b8SneQ9kSq HBwf11J/9cODivzbl3c8qRlfEl3gN3v8z7cdKbrorMLU2X815Xd5VTg8qKLw VYikx+fQgzzNk6VV9BkTg9tBjifLG4H1niw27y28WczlWb3ZZ9h24c1EpsGS C7u5hHeqa1B/ALetAY+H0Jhn2EeX9hQYRz9gSwgyWoiY8n0bdujmUtBcub0T FEPXB8Op4cGMX2BNDF/sYFQPdzM4fJaumrbFwDTGrurOOQZuItDfIhYlNngY kro4Og+P7hQjPaQMaWUORmg9oYnsIUTaRiK/JarPFwBRjwlcnENT2hsHk8SN ITvk0lVoGkoNvvdYjsAj2c74ZAXVvQtmaPOoFTe0RYe5MwNVpacnZFpUtEhk hHsC5CUsqRGH1RDG1Re2dc9cH3YJYxcc1ecpKjj4VmCa+z4xsVTkAmFiXyry jnilDD8y65Wmbwd+FW5sXFOYG9t+WuR4CpCW+ET0mDZzBAxqhZKteK5VJfL6 pDdUbuju07lYXCvc/60kJtKy8mnFSVsbUMrJ38onmpfotQH9xwlvSzGTIJZP dCmv73G6mYSyfLrZrLON6JKl5xFLp6bFhMSUCsHINm1rYtxdO2SRguzixBFT 97M8OfJb7cdTTGJHnk60Cx1SNp9weSVDJhPm/pqbPxRFS96D4WtToLMcphCt 2MmQauFW6Yy6yjXhdZQzHvdE615IGxWOzaFnQSW6TP1wvoBMyaBrkLF5DfJl Z3DV6q/Dv0S/o1rLJPRw+uQj3UT5xEton86TdT2GBtTQFELYTJskdQLXJtV5 MvwVKvTNYSgPnEHlVgGpb1uiTq7IeSQqoJFntXhCRxQt8AM3fowRQq02gcV8 0e0NIFyiAGDP/yM6jPojnC3Mupcqw38KeRalliQE+zEMD6nj+A07HFgfcHW1 qBPb9WJlUuuTLJo8Qw5F8gjvWxfDEeJ2W73uP1uvex3uIRb7Vkm3i/At8hRZ 0EGn1YaL66ur7nDYaQvgDXv9jN39rvuZm2H8BFOlHSYCIZ3YcJNoKWxA012V aH4eAm0YhKBHzqa2VyHkIefOCGrcRim56dRPnb8LatiwhyiEOIgVQtBxc56L 2rJrSxngT1uXMm4y5VxWyPKtU/aetaTyP6/UD2ximOzZeTzy/tfBAX//6+D0 9KR5fEzvAjcPD46K97++SvGCsW7QWRDOL7oNS2UBl33bGdHrSnoIUavVa7Wy yMJ8IaWb5brnarEF1e5Me6yam8F6U9xJC9ARNoXc8nAioHK5TDfGpbOXqXPR snItKl9I9CS/kNo95fbNm+57uVy20Qu6Bspy8abXulTgLy9hv/tCCtnJq5oX pVoJhh1wPq4DeiGFzyOlh7Jcv/5ZKcVi1uxyGT3lGX6nBhk/w67IMYT30YRy OWo/g7heK5eQ8oUM+za8+BvsazEjxP2JMCJKHIdjE0avHWO89uh6ix+4hAgx w7M095phoafEPfc+g13vLPO67RnXAB8lYUUJ57td+AlpwyvkV8ZhxulGncV/ EH1BRI/E6vaVYavHo/gWvebbal91apEQ2KzbWprFMkZKXgLHRWcVvPK2132d UnRpqQOxpCTcGeHOPqRqCDcjDyyzhByygSVUgGvLDPbdyTKp+mLfcyjX05ax RvvlsmbilgB0w/PDp5mK4Q3+MXefV0RiTFJWt1ez8Q8pl8s6c5ilA36cxaZ2 dYV/lylL26tpOLohKOptwj6CFH6rvpAecP5qqqtH7bIcO4UIgR8bfmsv+N9b Uut/ZJjokJ+ZxyPrf6N5cJis/4f0/sfhCYYExfr/FcqffoQ6XQB60/IMV2Tg ToE/ht8joyjTBSHs34J4RRp8NnNM1WdNdO+LvxzzrbtUlC1Kav5Hq05S81w8 Hpn/J4enR+L9r9PmEX//66RZ/P7PVynJaNMW+0nvbe2UzYV3tnbK75jrURJf o3YAUvMUrtR5CCqf0S+2bP9eGQyZR1c+gaUzF3qGFfwO0gAr3qo+nCAXFaOU 01pD5g/RsavySw/rmiRQN/RiPLGLi3BjqhqjFAmPAe1CPLoXVDFOogMM252D RgmNesqzRbwrUYxVIQRKsUgx8+zAJaouYzUYTpkFbhCyq6UWV5IHoH897JwJ 70o3hqZpP5AiJrFykEGcZBd727MQHUvmfTGMzCJ1eksajH/naAGN3gBZixX9 EtMiUvxqw3rU+K2NfAqPsub4gce8uZcjRZxzsZZIKqtuGZ1f0j+KHmXaUBFX s/xGRtzX5ODzi2tKwMHB36dzc3BUF2HpDlncUEoqH96KuM+mygp/Fbtta/xa lZvqTvnlZ5edcp+rIPuCIezvL70ZGUGYczoNsHAm4AxIZuFOWZlbtuMZ3jI1 SQ6nmRP4Xmihlm1xnOvATyoH6w10p9z5XZ1RkmrgqXcsxPGYiZIsmTs/vfsy 6qFM0pR2ojewnqYcPsk+Tzd8Gm6mGs7tS2omfisgrZ+FN7SeqKbErXymslKO Z0OdJayfTXMrdZexrNQ7C5+ht2cwsYy73UJzz2pxeXqLf9Yupbi47smKS1aQ rTS3DeNNVJiI8cV1yLMIMzrkdZ+lw3AZ3VqHmzLeVIehGF9Ah+LHB1OKW7fA r1rYISmUHLaNvnPjjqzCo3oRHKrWHML3vpZlrAKr3dXgQTVH3tzSRjNKStVX jlbcWwp2c3pM3cEmQnn6YIo+7mak2n3OIcUh/Nlm0YaGKr713qsoRSlKUYpS lKIUpShFKUpRilKUohSlKEUpSlGKUpSiFKUoRSlKUYpSlOcq/w/oFBb1AHgA AA== ------=_NextPart_000_004B_01C0DF88.FBB567D0--