Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iaLuH-0004J8-RE for pgsql-admin@arkaria.postgresql.org; Thu, 28 Nov 2019 15:40:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iaLuG-0005NT-D8 for pgsql-admin@arkaria.postgresql.org; Thu, 28 Nov 2019 15:40:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iaLuF-0005NM-Vo for pgsql-admin@lists.postgresql.org; Thu, 28 Nov 2019 15:40:36 +0000 Received: from mailgw99.suva.ch ([195.65.221.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iaLuC-0001P1-RV for pgsql-admin@postgresql.org; Thu, 28 Nov 2019 15:40:34 +0000 From: "William Sescu (Suva)" To: 'Tom Lane' CC: "pgsql-admin@postgresql.org" Subject: AW: AW: No result when selecting attstattarget from pg_attribute Thread-Topic: AW: No result when selecting attstattarget from pg_attribute Thread-Index: AdWl0bEhGeaHfnzqRLKRsCbkR6jAVQAIaBYAAAJ5kRD///X0gP//7HPg Date: Thu, 28 Nov 2019 15:40:29 +0000 Message-ID: References: <4078c426dbbb4e18a047ec00485adba9@suva.ch> <31263.1574952854@sss.pgh.pa.us> <9545ee300c12457f8ef09c8708d45f31@suva.ch> <328.1574954949@sss.pgh.pa.us> In-Reply-To: <328.1574954949@sss.pgh.pa.us> Accept-Language: en-US, de-CH X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.93.103.200] Content-Language: de-DE MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg="sha-256"; boundary="----DC36A4701EC50FB9AC08A7A7EC8AC095" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an S/MIME signed message ------DC36A4701EC50FB9AC08A7A7EC8AC095 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-version: 1.0 Thanks. It looks like that I have mixed up there a few things. Now it's clear. -----Urspr=FCngliche Nachricht----- Von: Tom Lane Gesendet: Donnerstag, 28. November 2019 16:29 An: Sescu William (SW0) Cc: pgsql-admin@postgresql.org Betreff: Re: AW: No result when selecting attstattarget from pg_attribute "William Sescu (Suva)" writes: > Thank you Tom for clarification. However, in regards of pg_upgrade, > which does not transfer statistics, how do I know how to create the "CREA= TE STATISTICS" on the new PostgreSQL version? You are apparently confusing the *definition* of a statistics object with t= he *content*. pg_upgrade will certainly transfer the former. Run ANALYZE to re-fill the latter. regards, tom lane ________________________________ Disclaimer: Diese Nachricht und ihr eventuell angeh=E4ngte Dateien sind nur f=FCr den A= dressaten bestimmt. Sie kann vertrauliche oder gesetzlich gesch=FCtzte Date= n oder Informationen beinhalten. Falls Sie diese Nachricht irrt=FCmlich err= eicht hat, bitten wir Sie h=F6flich, diese unter Ausschluss jeglicher Repro= duktion zu l=F6schen und die absendende Person zu benachrichtigen. Danke f= =FCr Ihre Hilfe. This message and any attached files are for the sole use of the recipient n= amed above. It may contain confidential or legally protected data or inform= ation. If you have received this message in error, please delete it without= making any copies whatsoever and notify the sender. Thank you for your ass= istance. ------DC36A4701EC50FB9AC08A7A7EC8AC095 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIIVPAYJKoZIhvcNAQcCoIIVLTCCFSkCAQExDTALBglghkgBZQMEAgEwCwYJKoZI hvcNAQcBoIISXDCCBWAwggNIoAMCAQICFHhYXy6tLBlL4zcHNTQTKLWW1GWTMA0G CSqGSIb3DQEBCwUAMEgxCzAJBgNVBAYTAkJNMRkwFwYDVQQKExBRdW9WYWRpcyBM aW1pdGVkMR4wHAYDVQQDExVRdW9WYWRpcyBSb290IENBIDEgRzMwHhcNMTIwMTEy MTcyNzQ0WhcNNDIwMTEyMTcyNzQ0WjBIMQswCQYDVQQGEwJCTTEZMBcGA1UEChMQ UXVvVmFkaXMgTGltaXRlZDEeMBwGA1UEAxMVUXVvVmFkaXMgUm9vdCBDQSAxIEcz MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAoL5QEI7p8mxAtASchbkx ytwt5BGpBDwbVcHnWDAdJLTD74XejCzhwT3fguZPrUeHbOxbScFK1buP7Iesf4Ka huw9A5lSAdI1nqza8FPJZjzUrAIB2iTTO6gCRq+kHOP4c1h2t/YOkA218M/M+vnG TOXDhjAKjRd+NevF37sOnMCNh+OIOIVn+j7Hq+ATnAUYmM+T9bGStPwj08/VxCdJ 4J48mwiji10qIeD8OapT2n1+zxoJU7xdBQTPoUqPi3aCDaH40scUd1uQNgeBmz4G +lJeY8WmAP6l6VIbUrWSOXIDCWK9sGAWbqbdJcIDZt3zBNFA4k6LhvRv5YOgJ4Re BMH1kL0wPcTvqGm8OJukpJbRYtppwAGWrsvEUTTqDKr/IY5Zj0pc5GGap9LpKniN UT06Fe6iWY6pXN7F+ZAi5YhFcd2RmWx6nz09mHxe9r4WaKBergsj/FoPqiJ2Lcmh EB3k00QjkIifxirm1/Was1geLzCJCBtUorWYI+wIdxyVXWHRy4mcX6JKkZrvIapJ FgiovWEoMcl0rYX22cWxi9HlEDJNX4sgOjxJHzOFWQ3bywl1Q2lz+2txffDfxEx9 xqMuyJV5y3Oijk5NJPte5AS+chumJy1JWpl611wJILd/lLlP8Q0cXohCGxG355Hb nmz0at+MBpgDrcwo76VH81MCAwEAAaNCMEAwDwYDVR0TAQH/BAUwAwEB/zAOBgNV HQ8BAf8EBAMCAQYwHQYDVR0OBBYEFKOX1vNeohDhq0WfPBdkPO4BcJzMMA0GCSqG SIb3DQEBCwUAA4ICAQAY+lt1/D56x193x8rfz1/DEsRAXdQyqrhq19UVFUaYI6Xm kFsYmUzjrUKjgjE2iM3p+8QElkiLAceNAc9bMwaWRmZ0HU/twba5tA1hzGN+1y53 jJYcKiNoa4VXdnAzE/7hT6Yjdxj6GozovWXJzz/0yRfc68e8wAQuLUYvaWbDG4/+ 7D7TypS/dgolDal7Ahyp0DtfC8CBOj1k4b+nLU69TcTYKcYiGNDFrHICgj+qOqI6 Ipcx3Qhjw3UUuWAoLVto4BapZoIjUfXrU9gxm3vpt51L64gWz/ldOIpJMI/t8esZ 9HcaMRhNZ1RsL29l+ds97CHsXvT0i8pgZVTRcWT0+aajgTM2M3HwpHhfTq2DId40 SY3oWayd8nZaNvIT9K/gCcdhKmz34J2uu4ZKKG8u7rR5zZAzw7N2+vXwbJ0BkPqe kPaccs9H2sMf5DUgU/JU0d9hg6YC4iU43oUyLV5zkFJdQsTOPUvh+RmEHdWiUMxB +0EUw73WyVqjY2YCgL0FOjtHnOwAJkz1iFG/qCN/GAewC+2LJqFk02FK61yf3rOv ZwOzH91tXWloaateOux8abzHO4VOnhW5tBVPw5V6WNfJbOlsufMpY160LPAtPe1a ZeCpW0DCSJmBbZ4fBio8ErSLD5uiJPCmjdZ64Eu2ZJZjlYTCSs0cLiSHM2DlwzCC BgAwggPooAMCAQICFC3Mf/7Q95NSNoq2VQLYGTrjHMlsMA0GCSqGSIb3DQEBCwUA MH0xCzAJBgNVBAYTAkNIMR4wHAYDVQRhDBVOVFJDSC1DSEUtMTEyLjIxMC4zNDkx JjAkBgNVBAoMHVF1b1ZhZGlzIFRydXN0bGluayBTY2h3ZWl6IEFHMSYwJAYDVQQD DB1RdW9WYWRpcyBTd2lzcyBBZHZhbmNlZCBDQSBHMzAeFw0xOTA1MjExMzU3MDha Fw0yMjA1MjExNDA3MDBaMIGDMQswCQYDVQQGEwJDSDEPMA0GA1UECAwGTHV6ZXJu MQ8wDQYDVQQHDAZMdXplcm4xDTALBgNVBAoMBFNVVkExHTAbBgNVBAMMFFdpbGxp YW0gU2VzY3UgKFN1dmEpMSQwIgYJKoZIhvcNAQkBFhV3aWxsaWFtLnNlc2N1QHN1 dmEuY2gwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDHMdH2IiHcwkm7 tUgKqqcjDw4ufOHCm19xkHKpFqoVHjqHFvBREs7ASSONCj+Pt0Sb3y/HmbWXJgzC tU3D9DlYiwkzOoNt2vNxEEQcvEZi1VWYCJGxtN/QD3wnv3GYT9RPzzATDET97QCi wgcYqRWIMgvoC8xQzRIRfJt28Zlk14wRCs1cOFMJUkRWG/z5/Zgu8Bv+Govl1ueU 8PuR9w8QmCba6PArDYhUHZ0LKrKDAsw2IR7mBCnitv5cJBV5PAuvgiyq+9uMN/QI sx3vncge2YfEdyu1xkD3mkXvTmESrT8NUr3Tv+Asxb9n3S7BC/atFD/kdIJV3j/G CeIjgqvfAgMBAAGjggFvMIIBazAfBgNVHSMEGDAWgBQGbLPpz+A7cF0eebe+8PZt fTaIIjB3BggrBgEFBQcBAQRrMGkwOAYIKwYBBQUHMAKGLGh0dHA6Ly90cnVzdC5x dW92YWRpc2dsb2JhbC5jb20vcXZjaGFkZzMuY3J0MC0GCCsGAQUFBzABhiFodHRw Oi8vdXcub2NzcC5xdW92YWRpc2dsb2JhbC5jb20wTgYDVR0gBEcwRTBDBgkrBgEE Ab5YAWQwNjA0BggrBgEFBQcCARYoaHR0cDovL3d3dy5xdW92YWRpc2dsb2JhbC5j b20vcmVwb3NpdG9yeTATBgNVHSUEDDAKBggrBgEFBQcDBDA7BgNVHR8ENDAyMDCg LqAshipodHRwOi8vY3JsLnF1b3ZhZGlzZ2xvYmFsLmNvbS9xdmNoYWRnMy5jcmww HQYDVR0OBBYEFKbIpSk77HsRZcx/a5hkdBsOcGRmMA4GA1UdDwEB/wQEAwIFoDAN BgkqhkiG9w0BAQsFAAOCAgEAkrHypcm40S3Bt0vvySd7yuM0GUJeXl/3ydpWvO+4 SPgtaNFsz2doYGAANW6bgqiDLKNjH25KWzz70q/ytKGGKUm5XNjRtP3aLs8dYwUI KqWf3Edw8s1vRuhwpOueXyIOEnnJ7oV9nLtARU58lA1La89evdqZ6z1Qt8iWG9Td LYHvY0iqEQUOeoe5GMYoAfma230TVuGSPD5qUQE2xE8o76kS5/kUdMdMoGtACNCu LHDExdss3Ul8P/Wqm0lJ0AsHIr4leYDtQB+e2CsGjm4QzYolZ3wKEtjS05RYbseU 9S8iy+Atya2yVgsmDdxxDMoSKzT4ZorNWKgX9CKssobDlTu5mNg3HSi3LGxrGsCd 7piCJGH0GqdtIk6iGC/cxcndCQtrlOWljcTUv2ikF1IjPiVvou4C/6iZwOCUuAFV E0Cdrjl59P4x8d7KHqgiv+hA2yqTBvpls2OLGBhTuCjL8U9pQ4v+Q+rXQCbq1Z2j VRc6UeSR+dTLvfI0NfqL77a37DsWHT2rtO1AYYd0gZVB+1C+GR8L5OH9byxm6dK3 VYnIyd2bHHLL3RdZIxvvG0a2eicfoYkA5X2UvhpJ8d72h7DGghxgP5hfziaJYUJ8 B8X3F/EGqPkGLoZ/Bux2rjftXbc1NJ2qoLHfTI7ecd0PLQH5k7rok7mojxEYN6I6 FI0wggbwMIIE2KADAgECAhRB6J7TViFJyJS923ve3X7FacckkDANBgkqhkiG9w0B AQsFADBIMQswCQYDVQQGEwJCTTEZMBcGA1UEChMQUXVvVmFkaXMgTGltaXRlZDEe MBwGA1UEAxMVUXVvVmFkaXMgUm9vdCBDQSAxIEczMB4XDTE4MDIxMzEzNTEwN1oX DTI4MDIxMTEzNTEwN1owfTELMAkGA1UEBhMCQ0gxHjAcBgNVBGEMFU5UUkNILUNI RS0xMTIuMjEwLjM0OTEmMCQGA1UECgwdUXVvVmFkaXMgVHJ1c3RsaW5rIFNjaHdl aXogQUcxJjAkBgNVBAMMHVF1b1ZhZGlzIFN3aXNzIEFkdmFuY2VkIENBIEczMIIC IjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA329pdBtbr7lHwGdxzEJH91mA nkWzHXLckl5mhgxX2cEc1AS3GqWjGBfoZmWwO1ORIRh0xxjM4gqSD1K94oSdkGvU JDqzM1bTtmzrVFrUiORzVMVjpZjGshmZuxFDekd7dS9poW2Lfsqx58uf/Qqg4rNa cAZv8tAavzaXCUSWEvOm/26jp6pad28aDoP+2y03jfkS2svKx1JT9ZjqUi/cWbW5 RubZNGehq9YcQTR/UmAKs7qNd07bwVgnZ0sD4U45dg07T/URRwVg0BfUxqX4/1ov fVW/Ezcnm684IbPCvUUFLUfMc+hEdvUJA+9gEgxBXDrlaQMcAamCznyFpQcgF+CA 9iAxNHhe1iAvDxR4YchjBI27jg27zNd2QOq37V4/jg1yTAy7TrAjvczwWhXsdqhK nj/H43ogifK8NC7noXxmecciRdRwyVlhs4BZGTNzS0bAsRnVOzPp6hyYCtu9oU9Q W6GdJkUY7qc67vP0w05bP0qic4HQShmXunrvA3MjLQeLlNbShdsL+IAVKqZ5kGO5 EXPNPls2zW5wfyQAzmBeV3MfelEbutH6PryonKa51WJB3PLPXZEW3ub3ccOBZOl0 +mHVPLC9VOn+Jl0Yop3KvstNzAQ4t4kujuh5u8e2LgRL6GquWduLM11DSPHfVDvO VowzFPOFqFi6i9+mCM0CAwEAAaOCAZswggGXMBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUo5fW816iEOGrRZ88F2Q87gFwnMwwdAYIKwYBBQUHAQEEaDBm MDgGCCsGAQUFBzAChixodHRwOi8vdHJ1c3QucXVvdmFkaXNnbG9iYWwuY29tL3F2 cmNhMWczLmNydDAqBggrBgEFBQcwAYYeaHR0cDovL29jc3AucXVvdmFkaXNnbG9i YWwuY29tMEkGA1UdIARCMEAwPgYEVR0gADA2MDQGCCsGAQUFBwIBFihodHRwOi8v d3d3LnF1b3ZhZGlzZ2xvYmFsLmNvbS9yZXBvc2l0b3J5MDMGA1UdJQQsMCoGCCsG AQUFBwMCBggrBgEFBQcDBAYKKwYBBAGCNwoDDAYIKwYBBQUHAwkwOwYDVR0fBDQw MjAwoC6gLIYqaHR0cDovL2NybC5xdW92YWRpc2dsb2JhbC5jb20vcXZyY2ExZzMu Y3JsMB0GA1UdDgQWBBQGbLPpz+A7cF0eebe+8PZtfTaIIjAOBgNVHQ8BAf8EBAMC AQYwDQYJKoZIhvcNAQELBQADggIBAGUd5HwFhK7lhaX0dd1QfDyKeDum1bFFphRm kJUMUnY0f+kfLwu4EEzpFZ1Bz6UMREnC1kVgkLj1bpqFPX6XB0AvCjcbPmMAWYrk 8H/3PcJ0LxwK3uwAWXPeS1R1o3QV9OBALnRRNpfqdcSSVFs8kaaX36OQiQhqGtTK 6YcGG0quRENym/ZRVMRoOmNsbcaUc3hSPTzRqMF7VPV2vGqqrnwzW74pxzKSneoW W96dfjZ80gV6Shx/x6xb/g/pYdQQLriPqLP0dgvPt7iESXHEmHY4rzwxVlHYKPJB QhXA0f+6yUE4UaV1RNVnMCeQGRS1HL9KyK3v8/AFWxW9akiBV0ROqRw6A/q7iWIc RKaxilm7scN6cCWty6W1Y26dJ6Xlb5QuIUZhYbPQuWMOSwOVTvcaU+zPfeJzcTlO u/dg+ZCGrXd5lx1S5exROVA5SnnZmzSc7L0BiInhLeLg9EGHz92a9yBAuOcMmOMh uCiU52LFFxeU6as1Ulm4QvJLdj3GOu2VWopArGE2M2Mj+ydBoes7q62dkmJZQP1R QgI8Owi/oyoQEvDQt9IDcSoFf3hHn7KCTjj1TWlGmUtyC7kA5gjcJ6IDxkEke5o6 0zQSXP885OybmWs/Ggs6TR6VWTQO1xr323Wned72KieH8L/qAWRHJx+EN9HnCAtE 5x0DMCDrMYICpjCCAqICAQEwgZUwfTELMAkGA1UEBhMCQ0gxHjAcBgNVBGEMFU5U UkNILUNIRS0xMTIuMjEwLjM0OTEmMCQGA1UECgwdUXVvVmFkaXMgVHJ1c3RsaW5r IFNjaHdlaXogQUcxJjAkBgNVBAMMHVF1b1ZhZGlzIFN3aXNzIEFkdmFuY2VkIENB IEczAhQtzH/+0PeTUjaKtlUC2Bk64xzJbDALBglghkgBZQMEAgGggeQwGAYJKoZI hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTkxMTI4MTU0MDMx WjAvBgkqhkiG9w0BCQQxIgQgi53ieOjB+uCs86zymqg09P40cRs2b+Q1K6IEVAaE YXcweQYJKoZIhvcNAQkPMWwwajALBglghkgBZQMEASowCwYJYIZIAWUDBAEWMAsG CWCGSAFlAwQBAjAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcN AwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEggEA JBhAIqbku7aUN7eF/ECd3fAhB7/7Y4iU2demBjl+gkvF38shN2GnMQ/Us6r5CCNt +bnYi/03rSk2STIdAa8J2lrLsyWPqbK0av9eheuz9Zca1iA8NbuobLN5dW3hMLg1 3yJs8NZf+welidTsxFTTWFeVrjao/sBypZDpDw0XwCgSpm3Hz6fnDQ3MKMiudSGw FVd0pfD1d0QwbAd878GwpQPxO+6xOiyGB/IV3gWTXhOiNadpfK+0sw9XJqh+u9/s MdNq1R0tUkfnNFTQwjP6j9+YTCOJtuckh1aEbF+sW3FsHzuqbsecpe9hVtOGHMyr z8OG6mihmJIxyg0JNERdnA== ------DC36A4701EC50FB9AC08A7A7EC8AC095--