Fwd: Stalled post to pgsql-general - Mailing list pgsql-www
From | Jim Nasby |
---|---|
Subject | Fwd: Stalled post to pgsql-general |
Date | |
Msg-id | 63de2785-e70c-72c3-7edd-cf4b4425d17f@nasby.net Whole thread Raw |
Responses |
Re: Fwd: Stalled post to pgsql-general
|
List | pgsql-www |
Just got this bounce for headers too large. While I admit 8K of headers is a bit excessive, I don't think there's anything I can do to affect that, and I suspect this could bite any other office365 users. -------- Forwarded Message -------- Received: from DM5PR11MB1643.namprd11.prod.outlook.com (10.172.38.14) by CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.10 via Mailbox Transport; Thu, 21 Jul 2016 22:03:57 +0000 Received: from SN1PR11CA0005.namprd11.prod.outlook.com (10.164.10.15) by DM5PR11MB1643.namprd11.prod.outlook.com (10.172.38.14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.10; Thu, 21 Jul 2016 22:03:56 +0000 Received: from BY2FFO11FD047.protection.gbl (2a01:111:f400:7c0c::161) by SN1PR11CA0005.outlook.office365.com (2a01:111:e400:c47b::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.10 via Frontend Transport; Thu, 21 Jul 2016 22:03:57 +0000 Authentication-Results: spf=none (sender IP is 217.196.149.56) smtp.mailfrom=postgresql.org; bluetreble.com; dkim=none (message not signed) header.d=none;bluetreble.com; dmarc=none action=none header.from=postgresql.org;bluetreble.com; dkim=none (message not signed) header.d=none; Received-SPF: None (protection.outlook.com: postgresql.org does not designate permitted sender hosts) Received: from malur.postgresql.org (217.196.149.56) by BY2FFO11FD047.mail.protection.outlook.com (10.1.15.175) with Microsoft SMTP Server (TLS) id 15.1.523.9 via Frontend Transport; Thu, 21 Jul 2016 22:03:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from <pgsql-general-owner@postgresql.org>) id 1bQM4Q-0006ap-PT for Jim.Nasby@bluetreble.com; Thu, 21 Jul 2016 22:03:54 +0000 X-Mailer: MIME-tools 5.505 (Entity 5.505) Date: Thu, 21 Jul 2016 22:03:54 +0000 From: pgsql-general-owner@postgresql.org To: Jim Nasby <Jim.Nasby@BlueTreble.com> Subject: Stalled post to pgsql-general Content-Type: multipart/mixed; boundary="----------=_1469138634-25343-1" Message-ID: <4ddb29a3f2c85076e3b5e98919de59c7e4582bc8@postgresql.org> Return-Path: pgsql-general-owner@postgresql.org X-MS-Exchange-Organization-Network-Message-Id: 04a8d802-ceba-4a0c-d722-08d3b1b2e97a X-EOPAttributedMessage: 0 X-EOPTenantAttributedMessage: 05027110-dcb3-458e-866d-b4ec88120732:0 X-MS-Exchange-Organization-MessageDirectionality: Incoming X-Forefront-Antispam-Report: CIP:217.196.149.56;IPV:NLI;CTRY:AT;EFV:NLI;SFV:NSPM;SFS:(6009001)(8156002)(2980300002)(428002)(199003)(189002)(119626001)(512954002)(9786002)(5003600100003)(7696003)(6806005)(7596002)(33646002)(450100001)(7636002)(7846002)(77096005)(86152002)(8676002)(19580395003)(36756003)(2876002)(19580405001)(50226002)(305945005)(86362001)(8896002)(356003)(106466001)(1096003)(246002)(2476003)(229853001)(4610100001)(76506005)(57986006)(586003)(84326002)(189998001)(260700001)(105586002)(101416001)(270700001)(100306002)(110136002)(107886002)(104016004)(5000100001)(92566002)(118296001)(50986999)(42522002);DIR:INB;SFP:;SCL:1;SRVR:DM5PR11MB1643;H:malur.postgresql.org;FPR:;SPF:None;PTR:malur.postgresql.org;A:1;MX:1;LANG:en; X-Microsoft-Exchange-Diagnostics: 1;BY2FFO11FD047;1:gX01l8cSrAovXBqwjbll1lXewmGY+AaKBvz1LFNpSUX7YhWybduwNjHkIIEpRiBvwiZ9xUvZIl8Tuz9zWGgOqjX+7gQjeQWl3u5OzsBz2icnm60WR/kgJHUwQEhbjeTUBwFe3zOwHSemM2UEjUY3h/17H+z58RytAkxz2OJX0wLIh13XNFaBdqG6Y8Aq0J2/UmuhzjsS/TkVbMIc7RVvfXz/EEzY+s0GfgjXjnfp13nVZWthD0hK7Vq5QA5tuBh1GS1P3WVShlUL7gObiXm2No3WJkkxMZXYs8J8/uwZnwLQ0jghDQqQJUxFt/+vAk22lKofcBM8Fy16PUrO/+pGvX7KR231nUkmeLEMwv+JZKZ/VopLxXB9iBXovI63IWIjXOtCTPqUSh6++FCA6ru7euFSPm1jefD4olMCOVq47th9SHPHETBBfxols5yUrOmQ17VzheWdu7Zdh2dEdr7gZSTM/K/rh+uN7k8IfFJXEGwR6MsCdKJewrT13+WRUQvEETLUHU9+G15eYFUol408yD5VL6laViWQr3qn5GgSvwI= X-MS-Office365-Filtering-Correlation-Id: 04a8d802-ceba-4a0c-d722-08d3b1b2e97a X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;2:PuNGhv3woG6M2xZFuHem+4elbJCdy1xDpx4rFQAS1J2e8Z8yP+unAZDj21KamNk4MFVijSL841mAjq57faOo/nUFK2iB6MHpitbMe7FOTs9PBQcQc+8e+AYRk5SCEpkGlAF6TsSXm8vFhZEnVIdqR1XjcXQPD2wDxPdLwQVT4cutEIkVUgFVXZX7ki2spHnL;3:B07hKfRrN4qZAF9kTsZzD6rA1r8/ohu8ImZo7bXB7Y6ISR11N0Tf572I+r03ETaEtM2C1tc9jmgf8y3IsC5QOeaKHB8COQX/soZSfYoF9icrclSbf9VQI+TIoWCsajHCDwkGhK8EeVp/pPwZj70VhshqL+snwNqOXPQkSk61LYOpqPPgDxfNdXTVqpOocrHWzBC/wmYLXE9mYb+Fh1cfyNuE4kPl4xVoD6/G1W1lThRUz24URJ2npDqXDDpnQNRimEn5FSgkFttp0ypH2a7zNinQcz3R3Ri0AdpvtoB06pc= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(71701004)(71702002);SRVR:DM5PR11MB1643; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;25:14dWTkoADPHCf+NNUEjYi24eEy4QbFiV3YfJCjmrwpSzsyd3U6UZ9KPDPGGUQpFjUuwVZBdmG7CpkNK+3BH/leKCVMtFa3uwHnht50vkYvs+kE+Pdy/TfePYHxSb1/ojvxaHdoYlvWcnMydfsKZxLA2pw95PJzrtMSVu/oIggaT9/oJ5nypCITi9eRQz4NDr7ez7gYJHOl/u+kdSL++DaSULW+htocSBiD0ibeNmzYVIU/KE3p11lj4rQBwHBte97xzRZkpXuv9DeIVvWebH2HzGSgibZ+Nj570FwEOtcFV69+K+vJs4rdEcCVYe+d5q5OoTffjaVe4OmpRSKTAySW7sLmA0DOv9Xs6PV146vaFHB/ghl1Q0st45H+Ts/7ivoL4on5yWE2xMyInnN5xg3dG4uvxcXLAblAVCcjYj/UFjhR3GJs/5tjpfN6FVGtuToS2yNv3L4npnObr1N8HaakcygNsgwGQsQgPPuqz++5eexqX6TiNjcYo59zxo7vAX0DRc0wgjIdw2+orwkMuYDCm1pWhY7vk7Wk57FykVuGKFDNvI5NGV9vc3r0joKbB4;31:Hp0LSR3z7CzvwA9ibWLj0iIZAbxq1BASw3lgO5NFnf0+qcy9Wuqq/ZdNaurg8zq+NzR5VQsYWabXiUjp4s1l4sSPnpFKNtUUyQ9Phvhl+eHmR2+y7D9f6yWQd7DP5rN/GLPvEideAK7gzvMLc0iqsTl1MMJJ9nNtbdtpd0IAtYJAMicZiOKE/tLbsH8803lH6Miy0zwws+7mn01xNDVa7Q== X-MS-Exchange-Organization-AVStamp-Service: 1.0 X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(102415321)(9101531078)(601004)(2401047)(7630418)(8121501046)(13018025)(13016025)(7631346)(7632298)(7633261)(10201501046)(3002001);SRVR:DM5PR11MB1643;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1643; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;4:Qvs43CNYOGaFsCRamuIu4/U7j6Wo09UWpHJmwYPPhdu5TDFA+36qiyKMuoxNFYhF1KXtSoIqYI0Lk0eOShvKxNM3ztfdNNKWHNYuvLx7YLIUUSBcTx7IbeinhUFcb7FrOYeDmVolXsWBvHgVc1ZVGVsPgGutezTKn+S7OejwcZ3uViqmSuGrsgX2cgt+oYJzqQYxxhhEQTRErXQ92Pu1ptq7mShaF/OCP3zpVqcPHlbOU3vaQ1pBbcoUwQNieajad3psxcwu0pD0eIce7ZkO6mt4bW9034ZPACylLPYoRKipFUpYurYovgAcyRGTCI69mHk7iik19m9qnZaklZ/46Gpe5qz4DVqTm/lEw3oVHVqeOgkRUmLmeF8Bhp91HdrHjZafmNY9IF3C9wjkSQ1EcqzXYH73aT8JmeZslPcMAhqXLzR6wI1aCerR1dX4VtcEKPM2qA2HA8Gys3apAiF64TicMNYmQGan7fa6B/6qa2WamkzcPWbnZihw5eWRrZ7f X-MS-Exchange-Organization-SCL: 1 X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;23:dSPPaVmRePV1krbrUHeuRy+/QUySRaCdF3N2wjeEmhXFETqdWhFUr6oViks/SQuuvdGiBOI2VSTpj1Ig4fKb1BKnUbQhfujVFc70jIVziFjGY5dWcgePxPw4sV1rD0rt+x0ZpED+aMLpS+bmv1Zb3W+ANFzFDpmUnvFAqpJHQxxAUa4fgjRZ+rppsVltd3jxBxQtuhPskk+IHeWQNeC/u1Ctw8YqKOry/WblQPkd9rv1UBUJaCQbzTS7913qAggc+3WQMkIeX7ieS2Bdt8d0G97kH6xaHwJV1OhfmKjoFQ6sd5seXHDJQEPQdeYVzT7FtqQPFgSQNPiHqrr8/Ed5hI1LOIi1tv8uPO+eJVb6plUl28rjsH66hzAevwu/KU1UWPJUqGO/drFQyqiZcpalpJ+AnJdJzfZkEhsGb0zdMHpkWyG2nvYk2l2DNlQWUFkSJDwEcoLFF1lKzbhcpgHgPB1EZgGAANQ+c/HnygNd+nF1wMs/iotRp3BSutCYe7tF06S12b+jXv4CcclFDSrAdUnL+DHSaZNRlYIEt23wOVxUBFYNRJjQEy5/RJUjO18W0HaPTQ8wEd9yQjEufcw8RusV+zNFxIwM5d5RBt0FL5itY6sG1x/FKhobL8JJABVia+OzD81ioxT32b8dFNWRGPtV98HpfgHuyr8UdEc7dTqDnj58xKkh7I588kMVNK0H8uAbiSgViZdPZSQJjomAR/k+u1WZRtqBVRwm6ZOvEU/rjtP8mIwXbTigSSzP366DPEtTmkGvHVG5wbvjriE88affBBaw/UmVmA+kESy8n1IZHslAAtvDsRpas1USgpakpuHSvzsrVuqyN37s6G9JhkatHPq2CiBZsGl0XozGExGsR8eIkyfi87/RbNLyi1mo28OZEU7q0PqhfeQsSwbaXSmsWh0d7u82oaW9M0r5xvHenYxJD8BbbAxa1zMl7pJzn0OmNVw8saZH+fLpFSmbx5JIDHIhGM1oQN4kabv1L5CCsJbHmglZBNvXC2qy2eVjIFOf+X0r0L20dPUCgGskzrCkNJwOu7WB/oKKHxsNa3s/CgZ2SJtSIMImor3yVo0yI9rYTI4ZBQq3Gu5FlBgLb9aBDNwtNmGO3JtgdZIcEL7cJIMFKEPnZA7uX2QWszFMSURVE+hpYLCp5QtIhLc6Nr4FVSrkhc2r8sC05pYGIfDaMKsXL8kLFrXBU2qdhLr+/K8zmNPfm/C2DEbgdjs/MXYQwib93ebKUGQQ0w3Xa6CDIpsCeK6MHSh2auq28k/Wn/PmWQ0GpFAMdPg0Rtu4bg== X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1643;6:h1Yux6e+TCPgnQmSdM6+p1+9ilHibwO5BsyQ8uX7mf2bcqs17FMprNGokKH7dj6nJBq2WcPn//qo2lUwJEhriXU0u+Gp+GuMHjCbMoIv9g3VhZDGV/7xTwuJCWe2hlsXQuIR9Y7S0KMr7GjwiXCTZmSxfMyBZSyI5BeD7AZob33Ci2ElJLYrRVdWFBTxnDfTGtMe/Gyrex+iweKwZU5T5UElZv6B/007qLmdmnggMgR/MZA2LYFBTLl2fiVzhH4fAGcAnHRxrtw4ISDatxKtpoo7w5ErwnPIN6MCAAtME3RmXK+iUWSyRqdCtUCoTMtQ;5:Bn++v8qeCM31o4EUBdEXuAH+qCmRZNTBsY5tbBSYs+tVPz+yCn1X05yvHsclFS455mEMvEfOiXcmzJGp+sh1PnP0b1183HQudd+R5mviYM+nQ8qytjG8LSZrLSO6yCaznemhbjLSsYdw0stnEuok+Q==;24:uovz29cF/UsMKISK0pYg7fhHAm7oGMMAXOA1XEBU3pNKAokAZR0rJJ313IOdGQh+m2daT0bRVP5+/P0pWkNGni1GY+erMS8FfIHcnIQRjl4=;7:3IyPlI/qq3GJ8NZ0T6SSIXXq0KmK2vbLGBbiAddfto0tCBfJxSqG3yKZPw3q1gsrXw+6cE1OL/fAwykai0uDLqwXoy9AoIopR38w9xFg+LATHCJbmifDb/qc31QC8jEFwxK23vg9nnE0mDC3jXCwucbPhXwdY2RNVeXe6KKKj5HERpOeoK+c/fT35rhcRRwjrzJ2ztTimFEJ7l+tl/j85Sxig0ofQpV44EDc0jIZ9cGVs9YFcqwQR+zIxceVeVd+FNXie3ffRaXg0yALy5dydA== SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Jul 2016 22:03:56.5220 (UTC) X-MS-Exchange-CrossTenant-Id: 05027110-dcb3-458e-866d-b4ec88120732 X-MS-Exchange-CrossTenant-FromEntityHeader: Internet X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1643 X-MS-Exchange-Organization-AuthSource: BY2FFO11FD047.protection.gbl X-MS-Exchange-Organization-AuthAs: Anonymous X-MS-Exchange-Transport-EndToEndLatency: 00:00:01.2025566 X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;9:mh+F1xXA37UmwoWEnkS2I/l1//0S69sMzAsJDm6MgRxMQ1WpCV9Ual3C/sDfdnYS/1KPpxNzIml3frO8u68PnzNjyCcm65IzowCKH54tPoApPodUGp09VUdB5eSsRmXXKdhAMmFdWv68gzcAmLz8QkdP6EGY9sT2ulUzZj50QRsp3ePj5Awc0sPRoZxOoOGXdy/4Ji+19R+3hndbLLDYzw== MIME-Version: 1.0 Your message to pgsql-general has been delayed, and requires the approval of the moderators, for the following reason(s): The message headers are too large (8193 > 8000) If you do not wish the message to be posted, or have other concerns, please send a message to the list owners at the following address: pgsql-general-owner@postgresql.org On 7/20/16 1:14 PM, Mark Lybarger wrote: > This leads me to think I need to create 2^5 or 32 unique constraints to > handle the various combinations of data that I can store. Another option would be to create a unique index of a bit varying field that set a bit to true for each field that was NULL WHERE <bit varying field> != 0. Let me know if you want to go that route, I could probably add that to http://pgxn.org/dist/count_nulls/ without much difficulty. Though, probably a better way to accomplish that would be to add a function to count_nulls that spits out an array of fields that are NULL; you could then do a unique index on that WHERE array != array[]. Maybe a less obtuse option would be to use a boolean array. Storage would be ~8x larger, but since there should be very few rows I doubt that matters. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461