| From: | "Rich Handler" <rich(at)oi(dot)co(dot)za> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Problem importing auto-increment fields in MS Access to PostgreSQL. |
| Date: | 2001-04-25 15:29:44 |
| Message-ID: | 3AE70988.6361.4CA61F@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi 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 (!) :
<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.
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)
Suggestions, workarounds and prayers would be appreciated !
love
rich handler
| Attachment | Content-Type | Size |
|---|---|---|
| psqlodbc.log | application/octet-stream | 3.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henshall, Stuart - WCP | 2001-04-26 08:08:20 | Re: Problem importing auto-increment fields in MS Access to Postg reSQL. |
| Previous Message | Kevin Kemp | 2001-04-24 22:10:26 | Re: Re: A proposal to change psqlodbc |