Received: from oi.co.za (oi.co.za [196.31.106.6]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3QBuW391389; Thu, 26 Apr 2001 07:56:35 -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 ; Thu, 26 Apr 2001 13:55:55 +0200 From: "Rich Handler" Organization: OgilvyInteractive To: pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org Date: Thu, 26 Apr 2001 13:55:55 +0200 MIME-Version: 1.0 Content-type: Multipart/Mixed; boundary=Message-Boundary-22055 Subject: Problem importing auto-increment fields in MS Access to Postgresql Reply-to: rich@oi.co.za Message-ID: <3AE828EB.30342.4AF3FBE@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200104/1078 X-Sequence-Number: 8295 --Message-Boundary-22055 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. I know there is no 'auto_number' type in PostgreSQL. I know also, that SERIAL and SEQUENCE are workarounds for this problem, but I'm not sure how to make a field a SERIAL once its already created in the table. I have tried making the DEFAULT value of field "id" set to SERIAL, but I get this error : FF00,0000,0000PostgreSQL said: ERROR: Attribute 'serial' not found  Your query:  ALTER TABLE "names" ALTER "id" SET DEFAULT SERIAL 0000,0000,0000This 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-22055 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: 25 Apr 2001, 13:08 Size: 3729 bytes. Type: Unknown --Message-Boundary-22055 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 O1NFUlZFUj10aHJlZWJhbmQub2kuY28uemE7UE9SVD01NDMyO1VJRD1hZG1p bjtQV0Q9KioqKio7UkVBRE9OTFk9MDtQUk9UT0NPTD02LjQ7RkFLRU9JRElO REVYPTE7U0hPV09JRENPTFVNTj0xO1JPV1ZFUlNJT05JTkc9MTtTSE9XU1lT VEVNVEFCTEVTPTE7Q09OTlNFVFRJTkdTPScKY29ubj0xNTQ0ODMyMTYsIHF1 ZXJ5PSdTRUxFQ1QgQ29uZmlnLCBuVmFsdWUgRlJPTSBNU3lzQ29uZicKRVJS T1IgZnJvbSBiYWNrZW5kIGR1cmluZyBzZW5kX3F1ZXJ5OiAnRVJST1I6ICBS ZWxhdGlvbiAnbXN5c2NvbmYnIGRvZXMgbm90IGV4aXN0JwpTVEFURU1FTlQg RVJST1I6IGZ1bmM9U0NfZXhlY3V0ZSwgZGVzYz0nJywgZXJybnVtPS0xLCBl cnJtc2c9J0Vycm9yIHdoaWxlIGV4ZWN1dGluZyB0aGUgcXVlcnkgKG5vbi1m YXRhbCknCiAgICAgICAgICAgICAgICAgLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAgICAg ICAgICAgICAgICAgaGRiYz0xNTQ0ODMyMTYsIHN0bXQ9MTU1NTgyNTM2LCBy ZXN1bHQ9MTU0NDc2NjA4CiAgICAgICAgICAgICAgICAgbWFudWFsX3Jlc3Vs dD0wLCBwcmVwYXJlPTAsIGludGVybmFsPTAKICAgICAgICAgICAgICAgICBi aW5kaW5ncz0wLCBiaW5kaW5nc19hbGxvY2F0ZWQ9MAogICAgICAgICAgICAg ICAgIHBhcmFtZXRlcnM9MCwgcGFyYW1ldGVyc19hbGxvY2F0ZWQ9MAogICAg ICAgICAgICAgICAgIHN0YXRlbWVudF90eXBlPTAsIHN0YXRlbWVudD0nU0VM RUNUIENvbmZpZywgblZhbHVlIEZST00gTVN5c0NvbmYnCiAgICAgICAgICAg ICAgICAgc3RtdF93aXRoX3BhcmFtcz0nU0VMRUNUIENvbmZpZywgblZhbHVl IEZST00gTVN5c0NvbmYnCiAgICAgICAgICAgICAgICAgZGF0YV9hdF9leGVj PS0xLCBjdXJyZW50X2V4ZWNfcGFyYW09LTEsIHB1dF9kYXRhPTAKICAgICAg ICAgICAgICAgICBjdXJyVHVwbGU9LTEsIGN1cnJlbnRfY29sPS0xLCBsb2Jq X2ZkPS0xCiAgICAgICAgICAgICAgICAgbWF4Um93cz0wLCByb3dzZXRfc2l6 ZT0xLCBrZXlzZXRfc2l6ZT0wLCBjdXJzb3JfdHlwZT0wLCBzY3JvbGxfY29u Y3VycmVuY3k9MQogICAgICAgICAgICAgICAgIGN1cnNvcl9uYW1lPSdTUUxf Q1VSMDk0NjAwNDgnCiAgICAgICAgICAgICAgICAgLS0tLS0tLS0tLS0tLS0t LVFSZXN1bHQgSW5mbyAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t CiAgICAgICAgICAgICAgICAgZmllbGRzPTE1NDQ3NzE4NCwgbWFudWFsX3R1 cGxlcz0wLCBiYWNrZW5kX3R1cGxlcz0wLCB0dXBsZUZpZWxkPTAsIGNvbm49 MAogICAgICAgICAgICAgICAgIGZldGNoX2NvdW50PTAsIGZjb3VudD0wLCBu dW1fZmllbGRzPTAsIGN1cnNvcj0nKE5VTEwpJwogICAgICAgICAgICAgICAg IG1lc3NhZ2U9JyhOVUxMKScsIGNvbW1hbmQ9JyhOVUxMKScsIG5vdGljZT0n KE5VTEwpJwogICAgICAgICAgICAgICAgIHN0YXR1cz02LCBpblR1cGxlcz0w CkNPTk4gRVJST1I6IGZ1bmM9U0NfZXhlY3V0ZSwgZGVzYz0nJywgZXJybnVt PTExMCwgZXJybXNnPSdFUlJPUjogIFJlbGF0aW9uICdtc3lzY29uZicgZG9l cyBub3QgZXhpc3QnCiAgICAgICAgICAgIC0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogICAg ICAgICAgICBoZW52PTE1NDQ3NjMxMiwgY29ubj0xNTQ0ODMyMTYsIHN0YXR1 cz0xLCBudW1fc3RtdHM9MTYKICAgICAgICAgICAgc29jaz0xNTQ0NzYzMzYs IHN0bXRzPTE1NDQ3NjM5MiwgbG9ial90eXBlPS05OTkKICAgICAgICAgICAg LS0tLS0tLS0tLS0tLS0tLSBTb2NrZXQgSW5mbyAtLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tCiAgICAgICAgICAgIHNvY2tldD02ODgsIHJldmVy c2U9MCwgZXJyb3JudW1iZXI9MCwgZXJyb3Jtc2c9JyhOVUxMKScKICAgICAg ICAgICAgYnVmZmVyX2luPTE1NDQ4OTY4OCwgYnVmZmVyX291dD0xNTQ0OTM3 OTIKICAgICAgICAgICAgYnVmZmVyX2ZpbGxlZF9pbj00NSwgYnVmZmVyX2Zp bGxlZF9vdXQ9MCwgYnVmZmVyX3JlYWRfaW49NDUKY29ubj0xNTQ0ODMyMTYs IHF1ZXJ5PSdDUkVBVEUgVEFCTEUgIm5hbWVzIigiaWQiIGludDQsIm5hbWUi IHZhcmNoYXIoNTApLCJ0ZWxfbm8iIHZhcmNoYXIoNTApKScKY29ubj0xNTQ0 ODMyMTYsIHF1ZXJ5PSdCRUdJTicKY29ubj0xNTQ0ODMyMTYsIHF1ZXJ5PSdJ TlNFUlQgSU5UTyAibmFtZXMiIFZBTFVFUyAoMSwnUmljaCBIYW5kbGVyJywn NDM0IDg2MzUnKScKY29ubj0xNTQ0ODMyMTYsIHF1ZXJ5PSdJTlNFUlQgSU5U TyAibmFtZXMiIFZBTFVFUyAoMiwnV2FycmVuJywnNTU1IDIxMzQnKScKY29u bj0xNTQ0ODMyMTYsIHF1ZXJ5PSdJTlNFUlQgSU5UTyAibmFtZXMiIFZBTFVF UyAoMywnQm9iJywnNTU1IDEyNDMnKScKY29ubj0xNTQ0ODMyMTYsIHF1ZXJ5 PSdJTlNFUlQgSU5UTyAibmFtZXMiIFZBTFVFUyAoNCwnbWFyeScsJzA5OCAw OSAwOScpJwpjb25uPTE1NDQ4MzIxNiwgcXVlcnk9J0NPTU1JVCcK --Message-Boundary-22055--