Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAR0gxx03056 for ; Sun, 26 Nov 2000 19:42:59 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from web9502.mail.yahoo.com (web9502.mail.yahoo.com [216.136.129.132]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAQA5UA84095 for ; Sun, 26 Nov 2000 05:05:30 -0500 (EST) (envelope-from bill_chatfield@yahoo.com) Message-ID: <20001126100519.84030.qmail@web9502.mail.yahoo.com> Received: from [24.95.66.135] by web9502.mail.yahoo.com; Sun, 26 Nov 2000 02:05:19 PST Date: Sun, 26 Nov 2000 02:05:19 -0800 (PST) From: Bill Chatfield Subject: PostgreSQL ODBC from MS Access numeric/float8 Error Fix To: pgsql-interfaces@postgresql.org Cc: alex@kv.minsk.by, bill_haase@excite.com MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-147571898-975233119=:83678" X-Archive-Number: 200011/250 X-Sequence-Number: 287 --0-147571898-975233119=:83678 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline I've created shell script which fixes this error: ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8' You will have to retype this query using an explicit cast The error occurs when you try to insert information into at PostgreSQL database from MS Access using ODBC. It is caused by the fact that there is no equals operator assigned to parameters of types numeric and float8. I don't know why Access is running a query with the types numeric and float8, but it is. I don't not have either of those types in my table. Here is the script, which works on Red Hat Linux 7. ===== Bill Chatfield At marchFIRST - 324-7677 - bill.chatfield@marchFIRST.com At Cardinal - 757-7038 - bill.chatfield@cardhealth.com At NetCommunity - bill.chatfield@netcommunity.com __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ --0-147571898-975233119=:83678 Content-Type: application/x-sh; name="fix_ms_access.sh" Content-Transfer-Encoding: base64 Content-Description: fix_ms_access.sh Content-Disposition: attachment; filename="fix_ms_access.sh" IyEvYmluL3NoCgojCiMgZml4X21zX2FjY2Vzcy5zaAojIEF1dGhvcjogQmls bCBDaGF0ZmllbGQgPGJpbGxfY2hhdGZpZWxkQHlhaG9vLmNvbT4KIyBUaGlz IHNjcmlwdCBpcyBkaXN0cmlidXRlZCB1bmRlciB0aGUgTEdQTC4KIwoKIwoj IFNjcmlwdCB0byBmaXggdGhlIHByb2JsZW0gd2l0aCB1c2luZyBNUyBBY2Nl c3MgdG8gbGluayB0byBhIFBvc3RncmVTUUwKIyB0YWJsZSBvdmVyIE9EQkMu CiMKIyBUaGlzIGlzIHRoZSBlcnJvciBtZXNzYWdlOgojCiMgRVJST1I6ICBV bmFibGUgdG8gaWRlbnRpZnkgYW4gb3BlcmF0b3IgJz0nIGZvciB0eXBlcyAn bnVtZXJpYycgYW5kICdmbG9hdDgnCiMgICAgICAgICBZb3Ugd2lsbCBoYXZl IHRvIHJldHlwZSB0aGlzIHF1ZXJ5IHVzaW5nIGFuIGV4cGxpY2l0IGNhc3QK IwojIEJVRyEgLSBUaGUgZXF1YWxzIG9wZXJhdG9yIGNhbid0IGJlIHJlbW92 ZWQgd2l0aCB0aGUgZHJvcCBjb21tYW5kLiAgSSBkb24ndAojICAgICAgICBr bm93IHdoeS4gICJkcm9wIG9wZXJhdG9yID0gKG51bWVyaWMsIGZsb2F0OCk7 IiBmYWlscy4KIwoKIwojIENoZWNrIGZvciBjb21tYW5kIGxpbmUgcGFyYW1l dGVyLgojCmlmIFsgJCMgLW5lIDEgXQp0aGVuCiAgICBlY2hvIHVzYWdlOiBm aXhfbXNfYWNjZXNzLnNoIFw8ZGJuYW1lXD4KICAgIGV4aXQgMQpmaQoKREJO QU1FPSQxCgojCiMgRmluZCBvdXQgd2hlcmUgdGhlIHBscGdzcWwgbGFuZ3Vh Z2UgbGlicmFyeSBpcy4KIwppZiBbICIkUEdMSUIiID0gIiIgXQp0aGVuCiAg ICBpZiBbIC1kIC91c3IvbGliL3Bnc3FsIF0KICAgIHRoZW4KICAgICAgICAj IFRoaXMgaXMgd2hlcmUgaXQgaXMgaW4gUmVkIEhhdCBMaW51eC4KICAgICAg ICBQR0xJQj0vdXNyL2xpYi9wZ3NxbAogICAgZWxzZQogICAgICAgIGVjaG8g UGxlYXNlIHNldCBQR0xJQiB0byB0aGUgZGlyZWN0b3J5IHdoZXJlIHBscGdz cWwuc28gaXMgbG9jYXRlZC4KICAgICAgICBleGl0IDEKICAgIGZpCmZpCgoj CiMgQWRkIHRoZSBwbHBnc3FsIHByb2NlZHVyYWwgbGFuZ3VhZ2UgdG8gUG9z dGdyZVNRTC4gIFRoZSBmdW5jdGlvbiBpcwojIHdyaXR0ZW4gaW4gdGhpcyBs YW5ndWFnZSwgc28gaXQgaXMgcmVxdWlyZWQuICBwbHBnc3FsIGhhZCB0byBi ZSB1c2VkCiMgYmVjYXVzZSB0aGUgZXF1aXZhbGVudCBzcWwgbGFuZ3VhZ2Ug c2NyaXB0IGNhdXNlcyB0aGUgYmFja2VuZCB0byBjcmFzaCwKIyB0Y2wgc3Vj a3MsIGFuZCBQTC9QZXJsIGlzIG5vdCBpbmNsdWRlZCBpbiBSZWQgSGF0IExp bnV4LiAgT2YgY291cnNlLCBDCiMgd291bGQgcmVxdWlyZSBhIG5hdGl2ZSBj b21waWxlZCBzaGFyZWQgbGlicmFyeSwgd2hpY2ggaXMgbm90IGVhc3kgdG8K IyBtb3ZlIGJldHdlZW4gYXJjaGl0ZWN0dXJlcy4KIwpjcmVhdGVsYW5nIHBs cGdzcWwgJERCTkFNRQoKIwojIEFkZCB0aGUgZXF1YWxzIG9wZXJhdG9yIGZv ciBudW1lcmljIGFuZCBmbG9hdDguCiMKcHNxbCAkREJOQU1FIDw8IkVPRiIK CmNyZWF0ZSBmdW5jdGlvbiBudW1lcmljX2VxX2Zsb2F0OChudW1lcmljLCBm bG9hdDgpIHJldHVybnMgYm9vbGVhbgphcwonCiAgICBERUNMQVJFCiAgICAg ICAgbnVtZXJpY192YXIgQUxJQVMgRk9SICQxOwogICAgICAgIGZsb2F0OF92 YXIgQUxJQVMgRk9SICQyOwogICAgQkVHSU4KICAgICAgICAtLSBQZXJmb3Jt IHRoZSBlcXVhbGl0eSBjaGVjayBieSBjYXN0aW5nIHRoZSBmbG9hdDggdG8g bnVtZXJpYy4KICAgICAgICBJRiBudW1lcmljX3ZhciA9IENBU1QoZmxvYXQ4 X3ZhciBhcyBudW1lcmljKSBUSEVOCiAgICAgICAgICAgIFJFVFVSTiB0cnVl OwogICAgICAgIEVMU0UKICAgICAgICAgICAgUkVUVVJOIGZhbHNlOwogICAg ICAgIEVORCBJRjsKICAgIEVORDsKJwpsYW5ndWFnZSAncGxwZ3NxbCc7IAoK Y3JlYXRlIGZ1bmN0aW9uIG51bWVyaWNfbmVfZmxvYXQ4KG51bWVyaWMsIGZs b2F0OCkgcmV0dXJucyBib29sZWFuCmFzCicKICAgIERFQ0xBUkUKICAgICAg ICBudW1lcmljX3ZhciBBTElBUyBGT1IgJDE7CiAgICAgICAgZmxvYXQ4X3Zh ciBBTElBUyBGT1IgJDI7CiAgICBCRUdJTgogICAgICAgIC0tIFBlcmZvcm0g dGhlIGVxdWFsaXR5IGNoZWNrIGJ5IGNhc3RpbmcgdGhlIGZsb2F0OCB0byBu dW1lcmljLgogICAgICAgIElGIG51bWVyaWNfdmFyID0gQ0FTVChmbG9hdDhf dmFyIGFzIG51bWVyaWMpIFRIRU4KICAgICAgICAgICAgUkVUVVJOIGZhbHNl OwogICAgICAgIEVMU0UKICAgICAgICAgICAgUkVUVVJOIHRydWU7CiAgICAg ICAgRU5EIElGOwogICAgRU5EOwonCmxhbmd1YWdlICdwbHBnc3FsJzsgCgpj cmVhdGUgb3BlcmF0b3IgPQooIAogICAgbGVmdGFyZz1udW1lcmljLCAKICAg IHJpZ2h0YXJnPWZsb2F0OCwgCiAgICBwcm9jZWR1cmU9bnVtZXJpY19lcV9m bG9hdDgsIAogICAgY29tbXV0YXRvcj0nPScsIAogICAgbmVnYXRvcj0nPD4n Cik7CgpjcmVhdGUgb3BlcmF0b3IgPD4KKCAKICAgIGxlZnRhcmc9bnVtZXJp YywgCiAgICByaWdodGFyZz1mbG9hdDgsIAogICAgcHJvY2VkdXJlPW51bWVy aWNfbmVfZmxvYXQ4LCAKICAgIGNvbW11dGF0b3I9Jzw+JywgCiAgICBuZWdh dG9yPSc9JwopOwoKRU9GCgo= --0-147571898-975233119=:83678--