Fwd: Stalled post to pgsql-general

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