X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DC98AD1B545 for ; Tue, 28 Oct 2003 05:43:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 20230-01 for ; Tue, 28 Oct 2003 01:43:11 -0400 (AST) Received: from timon.swistgroup.com (timon.swistgroup.com [196.44.35.13]) by svr1.postgresql.org (Postfix) with ESMTP id D0462D1B515 for ; Tue, 28 Oct 2003 01:43:07 -0400 (AST) Received: from steinmail.swistgroup.com ([172.16.1.3]) by timon.swistgroup.com with esmtp (Exim 4.24; FreeBSD 4.8) id 1AEMd6-0003yc-Ht for pgsql-interfaces@postgresql.org; Tue, 28 Oct 2003 07:42:56 +0200 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Content-Type: multipart/signed; boundary="----=_NextPart_000_0046_01C39D27.7D3B0090"; micalg=SHA1; protocol="application/x-pkcs7-signature" Date: Tue, 28 Oct 2003 07:45:42 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Message-ID: X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Index: AcOdFrmj4O1ZRsLSR0i3NHVr7/VnyA== From: "Cobus Carstens" To: X-Scan-Signature: e4780a369d9db8a4db16a9c20a400cfb X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/60 X-Sequence-Number: 4549 This is a multi-part message in MIME format. ------=_NextPart_000_0046_01C39D27.7D3B0090 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi there. I'm running Postgresql 7.3.2 on Mandrake 9.1. I'm using ecpg (version 2.10.0) to compile the embedded sql code in my C programs. The problem experienced has to do with array indexing in SQL statements. I browsed your test files in the CVS repository and found one (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/interfaces/ ecpg/test/test1.pgc?rev=1.31.2.1&content-type=text/x-cvsweb-markup) that contains the code I would like to be able to use. When I precompile the abovementioned file with ecpg, I get the following error test1.pgc:130: parse error at or near "[". It is the same problem I'm experiencing with my program. I tested my program on Postgresql 7.3.4 as well, but it also did not work (the ecpg version was the same as the 7.3.2's). What do you suggest I do to get this working? Grab latest code from CVS? My second question is with regards to Oracle style bulk inserts/updates. I've played around with the "COPY" command and it seems to have good performance (even though I have to explicitly sprintf all values in a string first). I'm currently working on a port of existing software that stores huge amounts of (telecoms) data, so performance is critical. Is there any special way of handling a lot of updates? I can understand that updates might need to be done one at a time, but it would be nice if I can cut out the overhead of calling an update sql statement repeatedly - I'm thinking in the line of the Oracle bulk updates where you give the sql statement and host arrays containing the fieldvalues for the different updates. Any hints/suggestions would be appreciated. Regards, Cobus Carstens ------=_NextPart_000_0046_01C39D27.7D3B0090 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIILeTCCBLMwggQcoAMCAQICEDaOMiTll3uKTeQ5lDDcJUYwDQYJKoZI hvcNAQEFBQAwgdExJjAkBgkqhkiG9w0BCQEWF3N3aXN0LWNhQHN3aXN0Z3Jv dXAuY29tMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw EAYDVQQHEwlDYXBlIFRvd24xKjAoBgNVBAoTIVN3aXN0IENvbXB1dGVyIFNl cnZpY2VzIChQdHkpIEx0ZDEqMCgGA1UECxMhU3dpc3QgQ29tcHV0ZXIgU2Vy dmljZXMgKFB0eSkgTHRkMRcwFQYDVQQDEw5Td2lzdGdyb3VwLmNvbTAeFw0w MjA3MzExNjMyMzlaFw0wNTA3MzExNjM5MTVaMIHRMSYwJAYJKoZIhvcNAQkB Fhdzd2lzdC1jYUBzd2lzdGdyb3VwLmNvbTELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMSowKAYDVQQK EyFTd2lzdCBDb21wdXRlciBTZXJ2aWNlcyAoUHR5KSBMdGQxKjAoBgNVBAsT IVN3aXN0IENvbXB1dGVyIFNlcnZpY2VzIChQdHkpIEx0ZDEXMBUGA1UEAxMO U3dpc3Rncm91cC5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANQ5 AVlCt14r929bFzdJDZTS0UOUbacxp4ifCYZvGJLzHPtTRkKh94PVngVUPQbV Ojq2Y5DSpLCcMU8pdPjGJlTl84d4AC3YuT3LlBrOnKqMLGah9jzD43h2/LdS LsTBSdEMOpF0p0KwFbA7Pg0ZWIXxk4cWANVn//fko32d6eEzAgMBAAGjggGI MIIBhDATBgkrBgEEAYI3FAIEBh4EAEMAQTALBgNVHQ8EBAMCAUYwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUcyj7tKm16Q3Dm/UKai3UI8zsZewwggEa BgNVHR8EggERMIIBDTCBxKCBwaCBvoaBu2xkYXA6Ly8vQ049U3dpc3Rncm91 cC5jb20oMiksQ049c3RlaW5kYyxDTj1DRFAsQ049UHVibGljJTIwS2V5JTIw U2VydmljZXMsQ049U2VydmljZXMsQ049Q29uZmlndXJhdGlvbixEQz1zd2lz dGdyb3VwLERDPWNvbT9jZXJ0aWZpY2F0ZVJldm9jYXRpb25MaXN0P2Jhc2U/ b2JqZWN0Y2xhc3M9Y1JMRGlzdHJpYnV0aW9uUG9pbnQwRKBCoECGPmh0dHA6 Ly9zdGVpbmRjLnN3aXN0Z3JvdXAuY29tL0NlcnRFbnJvbGwvU3dpc3Rncm91 cC5jb20oMikuY3JsMBIGCSsGAQQBgjcVAQQFAgMCAAIwDQYJKoZIhvcNAQEF BQADgYEAjrCidH1WT/fBHd2R8F7maFFsG2pSMMuMaktBhggelustUg6eL2xc VlOiDS+lCsryYX7z1CXlv2XN7bXFzG3uaP4iAJmUggKktQF2SN030Oa3zdF1 YcRdFiiWWrn0xYtZVvw0d/9T9zZXBa/vrbSUlGQp50ev2fOfEHao4FatcrMw gga+MIIGJ6ADAgECAgof4xmkAAIAAAIzMA0GCSqGSIb3DQEBBQUAMIHRMSYw JAYJKoZIhvcNAQkBFhdzd2lzdC1jYUBzd2lzdGdyb3VwLmNvbTELMAkGA1UE BhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBU b3duMSowKAYDVQQKEyFTd2lzdCBDb21wdXRlciBTZXJ2aWNlcyAoUHR5KSBM dGQxKjAoBgNVBAsTIVN3aXN0IENvbXB1dGVyIFNlcnZpY2VzIChQdHkpIEx0 ZDEXMBUGA1UEAxMOU3dpc3Rncm91cC5jb20wHhcNMDMwOTI1MDg0NTUyWhcN MDQwOTI0MDg0NTUyWjBHMSwwKgYJKoZIhvcNAQkBFh1jb2J1cy5jYXJzdGVu c0Bzd2lzdGdyb3VwLmNvbTEXMBUGA1UEAxMOQ29idXMgQ2Fyc3RlbnMwgZ8w DQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANVrp9EzQ723QrPqFMI5H3hjnWzN 2GA4RnKbfsX5xUSxYCY0nh7B4oKvk9So+hWlx0AUFWxxG8Irbq69ui7G6UZk eYixfnDMeouIR4FWJqJ+b79i184vI5Ts1CovDoDNk+T8lz3lEC4993IHsgGu Yk4uPOE+i41Z9fLlEhXVfbbdAgMBAAGjggQkMIIEIDALBgNVHQ8EBAMCBaAw HQYDVR0OBBYEFB5u9QICIVlAwg3+yQYCZAs3w1oqMBcGCSsGAQQBgjcUAgQK HggAVQBzAGUAcjCCAQ8GA1UdIwSCAQYwggECgBRzKPu0qbXpDcOb9QpqLdQj zOxl7KGB16SB1DCB0TEmMCQGCSqGSIb3DQEJARYXc3dpc3QtY2FAc3dpc3Rn cm91cC5jb20xCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUx EjAQBgNVBAcTCUNhcGUgVG93bjEqMCgGA1UEChMhU3dpc3QgQ29tcHV0ZXIg U2VydmljZXMgKFB0eSkgTHRkMSowKAYDVQQLEyFTd2lzdCBDb21wdXRlciBT ZXJ2aWNlcyAoUHR5KSBMdGQxFzAVBgNVBAMTDlN3aXN0Z3JvdXAuY29tghA2 jjIk5Zd7ik3kOZQw3CVGMIIBGgYDVR0fBIIBETCCAQ0wgcSggcGggb6Ggbts ZGFwOi8vL0NOPVN3aXN0Z3JvdXAuY29tKDIpLENOPXN0ZWluZGMsQ049Q0RQ LENOPVB1YmxpYyUyMEtleSUyMFNlcnZpY2VzLENOPVNlcnZpY2VzLENOPUNv bmZpZ3VyYXRpb24sREM9c3dpc3Rncm91cCxEQz1jb20/Y2VydGlmaWNhdGVS ZXZvY2F0aW9uTGlzdD9iYXNlP29iamVjdGNsYXNzPWNSTERpc3RyaWJ1dGlv blBvaW50MESgQqBAhj5odHRwOi8vc3RlaW5kYy5zd2lzdGdyb3VwLmNvbS9D ZXJ0RW5yb2xsL1N3aXN0Z3JvdXAuY29tKDIpLmNybDCCASgGCCsGAQUFBwEB BIIBGjCCARYwgbAGCCsGAQUFBzAChoGjbGRhcDovLy9DTj1Td2lzdGdyb3Vw LmNvbSxDTj1BSUEsQ049UHVibGljJTIwS2V5JTIwU2VydmljZXMsQ049U2Vy dmljZXMsQ049Q29uZmlndXJhdGlvbixEQz1zd2lzdGdyb3VwLERDPWNvbT9j QUNlcnRpZmljYXRlP2Jhc2U/b2JqZWN0Y2xhc3M9Y2VydGlmaWNhdGlvbkF1 dGhvcml0eTBhBggrBgEFBQcwAoZVaHR0cDovL3N0ZWluZGMuc3dpc3Rncm91 cC5jb20vQ2VydEVucm9sbC9zdGVpbmRjLnN3aXN0Z3JvdXAuY29tX1N3aXN0 Z3JvdXAuY29tKDIpLmNydDApBgNVHSUEIjAgBgorBgEEAYI3CgMEBggrBgEF BQcDBAYIKwYBBQUHAwIwUQYDVR0RBEowSKAnBgorBgEEAYI3FAIDoBkMF2Nh cnN0ZW5jQHN3aXN0Z3JvdXAuY29tgR1jb2J1cy5jYXJzdGVuc0Bzd2lzdGdy b3VwLmNvbTANBgkqhkiG9w0BAQUFAAOBgQAlrjXGp+ot/VPVhrwPx8HWNvMQ nj3k3boupD1TYvSYvsHAGuCxVSIU6C7tGOPHjshCPPDTur9xia5KBdAbzcaM ZoKIG1sV6q9rVe6JCALEv0U8MBRv5ZWNLLnX3iu484bhrHDYnpAvwGJQtgVM lCh2xO94nHhQLERJMHsytjb3iTGCBDswggQ3AgEBMIHgMIHRMSYwJAYJKoZI hvcNAQkBFhdzd2lzdC1jYUBzd2lzdGdyb3VwLmNvbTELMAkGA1UEBhMCWkEx FTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMSow KAYDVQQKEyFTd2lzdCBDb21wdXRlciBTZXJ2aWNlcyAoUHR5KSBMdGQxKjAo BgNVBAsTIVN3aXN0IENvbXB1dGVyIFNlcnZpY2VzIChQdHkpIEx0ZDEXMBUG A1UEAxMOU3dpc3Rncm91cC5jb20CCh/jGaQAAgAAAjMwCQYFKw4DAhoFAKCC ArAwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcN MDMxMDI4MDU0NTQyWjAjBgkqhkiG9w0BCQQxFgQUC+OI9rkp7xTLjD3Jnplt N6chh0owZwYJKoZIhvcNAQkPMVowWDAKBggqhkiG9w0DBzAHBgUrDgMCGjAO BggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZI hvcNAwICASgwCgYIKoZIhvcNAgUwgfEGCSsGAQQBgjcQBDGB4zCB4DCB0TEm MCQGCSqGSIb3DQEJARYXc3dpc3QtY2FAc3dpc3Rncm91cC5jb20xCzAJBgNV BAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUg VG93bjEqMCgGA1UEChMhU3dpc3QgQ29tcHV0ZXIgU2VydmljZXMgKFB0eSkg THRkMSowKAYDVQQLEyFTd2lzdCBDb21wdXRlciBTZXJ2aWNlcyAoUHR5KSBM dGQxFzAVBgNVBAMTDlN3aXN0Z3JvdXAuY29tAgof4xmkAAIAAAIzMIHzBgsq hkiG9w0BCRACCzGB46CB4DCB0TEmMCQGCSqGSIb3DQEJARYXc3dpc3QtY2FA c3dpc3Rncm91cC5jb20xCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJu IENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEqMCgGA1UEChMhU3dpc3QgQ29t cHV0ZXIgU2VydmljZXMgKFB0eSkgTHRkMSowKAYDVQQLEyFTd2lzdCBDb21w dXRlciBTZXJ2aWNlcyAoUHR5KSBMdGQxFzAVBgNVBAMTDlN3aXN0Z3JvdXAu Y29tAgof4xmkAAIAAAIzMA0GCSqGSIb3DQEBAQUABIGAXk0KAVV+FBERvTmf Iz2bGvlg4L7n/AiLvbCm/4Xe2TPD1Pggxubf/f2K2PE0R8nEvs7mVLBPi+pJ Srdz0B25kt64ibCu5WyRmqEkkT7gw1MNQr6bMjab475irqL0aeJn4bXBAJz2 +KsCyD4I0bI7tXMYjRsaZAVFvpHrmOWnKeUAAAAAAAA= ------=_NextPart_000_0046_01C39D27.7D3B0090--