Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3QC1G393594 for ; Thu, 26 Apr 2001 08:01:16 -0400 (EDT) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from oi.co.za (oi.co.za [196.31.106.6]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3NIiD335368 for ; Mon, 23 Apr 2001 14:44:17 -0400 (EDT) (envelope-from rich@oi.co.za) Received: from bonsai (unverified [196.31.106.137]) by mail.oi.co.za (EMWAC SMTPRS 0.83) with SMTP id ; Mon, 23 Apr 2001 20:43:32 +0200 From: "Rich Handler" Organization: OgilvyInteractive To: pgsql-interfaces@postgresql.org Date: Mon, 23 Apr 2001 20:43:31 +0200 MIME-Version: 1.0 Content-type: Multipart/Mixed; boundary=Message-Boundary-8765 Subject: Problem importing auto-increment fields in MS Access to PostgreSQL. Reply-to: rich@oi.co.za Message-ID: <3AE493F3.25516.28C11A4@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200104/113 X-Sequence-Number: 1497 --Message-Boundary-8765 Content-type: text/enriched; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body 0100,0100,0100Hi there I have a relatively simple problem : I have a field named "id" that has type "Auto-number" in an Access database table. When I export the database via ODBC to a PostgreSQL table, the "auto- number" property of this field is lost (!) : < CREATE TABLE "names"("id" int4,"name" varchar(50),"tel_no" varchar(50)) < I also access the PostgreSQL database via a web-based GUI (phpPgAdmin from GreatBridge), and when I add new rows to it, the id field does not auto- increment. This is my system : odbc driver version (on Win machine) : 7.01.00.04 Insight Distrib. (PSQLODBC.DLL) odbc driver version (on Red Hat machine) : postgresql-odbc-7.0.2-17.rpm postgre database version : postgresql-7.0.2.rpm error messages on screen : none. the commlog file : see attached file (psqlodbc.log) 0100,0100,0100Suggestions, workarounds and prayers would be appreciated ! love rich handler --Message-Boundary-8765 Content-type: text/plain; charset=US-ASCII Content-disposition: inline Content-description: Attachment information. The following section of this message contains a file attachment prepared for transmission using the Internet MIME message format. If you are using Pegasus Mail, or any another MIME-compliant system, you should be able to save it or view it from within your mailer. If you cannot, please ask your system administrator for assistance. ---- File information ----------- File: psqlodbc.log Date: 23 Apr 2001, 20:35 Size: 3731 bytes. Type: Unknown --Message-Boundary-8765 Content-type: Application/Octet-stream; name="psqlodbc.log"; type=Unknown Content-disposition: attachment; filename="psqlodbc.log" Content-transfer-encoding: BASE64 Y29ubj0xNTQ0ODMyMTYsIFNRTERyaXZlckNvbm5lY3QoIGluKT0nRFNOPXRl c3RvZGJjOycsIGZEcml2ZXJDb21wbGV0aW9uPTEKRFNOIGluZm86IERTTj0n dGVzdG9kYmMnLHNlcnZlcj0ndGhyZWViYW5kZWQub2kuY28uemEnLHBvcnQ9 JzU0MzInLGRiYXNlPSd0ZXN0Jyx1c2VyPSdhZG1pbicscGFzc3dkPScqKioq KionCiAgICAgICAgICBvbmx5cmVhZD0nMCcscHJvdG9jb2w9JzYuNCcsc2hv d29pZD0nMScsZmFrZW9pZGluZGV4PScxJyxzaG93c3lzdGFibGU9JzEnCiAg ICAgICAgICBjb25uX3NldHRpbmdzPScnCiAgICAgICAgICB0cmFuc2xhdGlv bl9kbGw9JycsdHJhbnNsYXRpb25fb3B0aW9uPScnCkdsb2JhbCBPcHRpb25z OiBWZXJzaW9uPScwNy4wMS4wMDA0JywgZmV0Y2g9MTAwLCBzb2NrZXQ9NDA5 NiwgdW5rbm93bl9zaXplcz0wLCBtYXhfdmFyY2hhcl9zaXplPTI1NCwgbWF4 X2xvbmd2YXJjaGFyX3NpemU9ODE5MAogICAgICAgICAgICAgICAgZGlzYWJs ZV9vcHRpbWl6ZXI9MSwga3Nxbz0xLCB1bmlxdWVfaW5kZXg9MSwgdXNlX2Rl Y2xhcmVmZXRjaD0wCiAgICAgICAgICAgICAgICB0ZXh0X2FzX2xvbmd2YXJj aGFyPTEsIHVua25vd25zX2FzX2xvbmd2YXJjaGFyPTAsIGJvb2xzX2FzX2No YXI9MQogICAgICAgICAgICAgICAgZXh0cmFfc3lzdGFibGVfcHJlZml4ZXM9 J2RkXzsnLCBjb25uX3NldHRpbmdzPScnCmNvbm49MTU0NDgzMjE2LCBxdWVy eT0nICcKY29ubj0xNTQ0ODMyMTYsIHF1ZXJ5PSdzZXQgRGF0ZVN0eWxlIHRv ICdJU08nJwpjb25uPTE1NDQ4MzIxNiwgcXVlcnk9J3NldCBnZXFvIHRvICdP RkYnJwpjb25uPTE1NDQ4MzIxNiwgcXVlcnk9J3NldCBrc3FvIHRvICdPTicn CmNvbm49MTU0NDgzMjE2LCBxdWVyeT0nc2VsZWN0IG9pZCBmcm9tIHBnX3R5 cGUgd2hlcmUgdHlwbmFtZT0nbG8nJwogICAgWyBmZXRjaGVkIDAgcm93cyBd CmNvbm49MTU0NDgzMjE2LCBxdWVyeT0nc2VsZWN0IHZlcnNpb24oKScKICAg IFsgZmV0Y2hlZCAxIHJvd3MgXQogICAgWyBQb3N0Z3JlU1FMIHZlcnNpb24g c3RyaW5nID0gJ1Bvc3RncmVTUUwgNy4wLjIgb24gaTY4Ni1wYy1saW51eC1n bnUsIGNvbXBpbGVkIGJ5IGdjYyAyLjk2JyBdCiAgICBbIFBvc3RncmVTUUwg dmVyc2lvbiBudW1iZXIgPSAnNy4wJyBdCmNvbm49MTU0NDgzMjE2LCBTUUxE cml2ZXJDb25uZWN0KG91dCk9J0RTTj10ZXN0b2RiYztEQVRBQkFTRT10ZXN0 O1NFUlZFUj10aHJlZWJhbmRlZC5vaS5jby56YTtQT1JUPTU0MzI7VUlEPWFk bWluO1BXRD0qKioqKjtSRUFET05MWT0wO1BST1RPQ09MPTYuNDtGQUtFT0lE SU5ERVg9MTtTSE9XT0lEQ09MVU1OPTE7Uk9XVkVSU0lPTklORz0xO1NIT1dT WVNURU1UQUJMRVM9MTtDT05OU0VUVElOR1M9Jwpjb25uPTE1NDQ4MzIxNiwg cXVlcnk9J1NFTEVDVCBDb25maWcsIG5WYWx1ZSBGUk9NIE1TeXNDb25mJwpF UlJPUiBmcm9tIGJhY2tlbmQgZHVyaW5nIHNlbmRfcXVlcnk6ICdFUlJPUjog IFJlbGF0aW9uICdtc3lzY29uZicgZG9lcyBub3QgZXhpc3QnClNUQVRFTUVO VCBFUlJPUjogZnVuYz1TQ19leGVjdXRlLCBkZXNjPScnLCBlcnJudW09LTEs IGVycm1zZz0nRXJyb3Igd2hpbGUgZXhlY3V0aW5nIHRoZSBxdWVyeSAobm9u LWZhdGFsKScKICAgICAgICAgICAgICAgICAtLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KICAg ICAgICAgICAgICAgICBoZGJjPTE1NDQ4MzIxNiwgc3RtdD0xNTU1ODI1MzYs IHJlc3VsdD0xNTQ0NzY2MDgKICAgICAgICAgICAgICAgICBtYW51YWxfcmVz dWx0PTAsIHByZXBhcmU9MCwgaW50ZXJuYWw9MAogICAgICAgICAgICAgICAg IGJpbmRpbmdzPTAsIGJpbmRpbmdzX2FsbG9jYXRlZD0wCiAgICAgICAgICAg ICAgICAgcGFyYW1ldGVycz0wLCBwYXJhbWV0ZXJzX2FsbG9jYXRlZD0wCiAg ICAgICAgICAgICAgICAgc3RhdGVtZW50X3R5cGU9MCwgc3RhdGVtZW50PSdT RUxFQ1QgQ29uZmlnLCBuVmFsdWUgRlJPTSBNU3lzQ29uZicKICAgICAgICAg ICAgICAgICBzdG10X3dpdGhfcGFyYW1zPSdTRUxFQ1QgQ29uZmlnLCBuVmFs dWUgRlJPTSBNU3lzQ29uZicKICAgICAgICAgICAgICAgICBkYXRhX2F0X2V4 ZWM9LTEsIGN1cnJlbnRfZXhlY19wYXJhbT0tMSwgcHV0X2RhdGE9MAogICAg ICAgICAgICAgICAgIGN1cnJUdXBsZT0tMSwgY3VycmVudF9jb2w9LTEsIGxv YmpfZmQ9LTEKICAgICAgICAgICAgICAgICBtYXhSb3dzPTAsIHJvd3NldF9z aXplPTEsIGtleXNldF9zaXplPTAsIGN1cnNvcl90eXBlPTAsIHNjcm9sbF9j b25jdXJyZW5jeT0xCiAgICAgICAgICAgICAgICAgY3Vyc29yX25hbWU9J1NR TF9DVVIwOTQ2MDA0OCcKICAgICAgICAgICAgICAgICAtLS0tLS0tLS0tLS0t LS0tUVJlc3VsdCBJbmZvIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0KICAgICAgICAgICAgICAgICBmaWVsZHM9MTU0NDc3MTg0LCBtYW51YWxf dHVwbGVzPTAsIGJhY2tlbmRfdHVwbGVzPTAsIHR1cGxlRmllbGQ9MCwgY29u bj0wCiAgICAgICAgICAgICAgICAgZmV0Y2hfY291bnQ9MCwgZmNvdW50PTAs IG51bV9maWVsZHM9MCwgY3Vyc29yPScoTlVMTCknCiAgICAgICAgICAgICAg ICAgbWVzc2FnZT0nKE5VTEwpJywgY29tbWFuZD0nKE5VTEwpJywgbm90aWNl PScoTlVMTCknCiAgICAgICAgICAgICAgICAgc3RhdHVzPTYsIGluVHVwbGVz PTAKQ09OTiBFUlJPUjogZnVuYz1TQ19leGVjdXRlLCBkZXNjPScnLCBlcnJu dW09MTEwLCBlcnJtc2c9J0VSUk9SOiAgUmVsYXRpb24gJ21zeXNjb25mJyBk b2VzIG5vdCBleGlzdCcKICAgICAgICAgICAgLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAg ICAgICAgICAgIGhlbnY9MTU0NDc2MzEyLCBjb25uPTE1NDQ4MzIxNiwgc3Rh dHVzPTEsIG51bV9zdG10cz0xNgogICAgICAgICAgICBzb2NrPTE1NDQ3NjMz Niwgc3RtdHM9MTU0NDc2MzkyLCBsb2JqX3R5cGU9LTk5OQogICAgICAgICAg ICAtLS0tLS0tLS0tLS0tLS0tIFNvY2tldCBJbmZvIC0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0KICAgICAgICAgICAgc29ja2V0PTY4OCwgcmV2 ZXJzZT0wLCBlcnJvcm51bWJlcj0wLCBlcnJvcm1zZz0nKE5VTEwpJwogICAg ICAgICAgICBidWZmZXJfaW49MTU0NDg5Njg4LCBidWZmZXJfb3V0PTE1NDQ5 Mzc5MgogICAgICAgICAgICBidWZmZXJfZmlsbGVkX2luPTQ1LCBidWZmZXJf ZmlsbGVkX291dD0wLCBidWZmZXJfcmVhZF9pbj00NQpjb25uPTE1NDQ4MzIx NiwgcXVlcnk9J0NSRUFURSBUQUJMRSAibmFtZXMiKCJpZCIgaW50NCwibmFt ZSIgdmFyY2hhcig1MCksInRlbF9ubyIgdmFyY2hhcig1MCkpJwpjb25uPTE1 NDQ4MzIxNiwgcXVlcnk9J0JFR0lOJwpjb25uPTE1NDQ4MzIxNiwgcXVlcnk9 J0lOU0VSVCBJTlRPICJuYW1lcyIgVkFMVUVTICgxLCdSaWNoIEhhbmRsZXIn LCc0MzQgODYzNScpJwpjb25uPTE1NDQ4MzIxNiwgcXVlcnk9J0lOU0VSVCBJ TlRPICJuYW1lcyIgVkFMVUVTICgyLCdXYXJyZW4nLCc1NTUgMjEzNCcpJwpj b25uPTE1NDQ4MzIxNiwgcXVlcnk9J0lOU0VSVCBJTlRPICJuYW1lcyIgVkFM VUVTICgzLCdCb2InLCc1NTUgMTI0MycpJwpjb25uPTE1NDQ4MzIxNiwgcXVl cnk9J0lOU0VSVCBJTlRPICJuYW1lcyIgVkFMVUVTICg0LCdtYXJ5JywnMDk4 IDA5IDA5JyknCmNvbm49MTU0NDgzMjE2LCBxdWVyeT0nQ09NTUlUJwo= --Message-Boundary-8765--