Problem importing auto-increment fields in MS Access to PostgreSQL
От | Rich Handler |
---|---|
Тема | Problem importing auto-increment fields in MS Access to PostgreSQL |
Дата | |
Msg-id | 3AE6CC93.14891.B39401F@localhost обсуждение исходный текст |
Список | pgsql-general |
<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. When I export the database via ODBC to a PostgreSQL table, the "auto- number" property of this field is lost (!) : <<snippet of commlog> CREATE TABLE "names"("id" int4,"name" varchar(50),"tel_no" varchar(50)) <</snippet> 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. <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 ------- End of forwarded message ------- <nofill> Rich Handler OgilvyInteractive 18 Roeland St, Gardens, 8001, Cape Town Fon 021 467 1402 Fax 021 467 1401 http://www.oi.co.za/ 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-general по дате отправления: