Problem importing auto-increment fields in MS Access to Postgresql
От | Rich Handler |
---|---|
Тема | Problem importing auto-increment fields in MS Access to Postgresql |
Дата | |
Msg-id | 3AE828EB.30342.4AF3FBE@localhost обсуждение исходный текст |
Список | pgsql-interfaces |
<color><param>0100,0100,0100</param>Hi there <bold>I have a relatively simple problem : </bold> 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 : <color><param>FF00,0000,0000</param>PostgreSQL said: ERROR: Attribute 'serial' not found Your query: <bold>ALTER TABLE "names" ALTER "id" SET DEFAULT SERIAL</bold> <bold><color><param>0000,0000,0000</param>This is my system : </bold> 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) <color><param>0100,0100,0100</param>Suggestions, workarounds and prayers would be appreciated ! love rich handler 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
Вложения
В списке pgsql-interfaces по дате отправления: