Re: Conversion from MS Access to Postgresql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Len Morgan" <len-morgan(at)crcom(dot)net>
Cc: "Andrew McMillan" <Andrew(at)catalyst(dot)net(dot)nz>, "G(dot)L(dot)Lim" <limgl(at)grouplinks(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Conversion from MS Access to Postgresql
Date: 2000-06-27 08:32:08
Message-ID: 8610.962094728@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Len Morgan" <len-morgan(at)crcom(dot)net> writes:
> ... I cannot seem to make Postgres join two
> tables when the type of one is char(9) and the other is character
> varying(9). The machine seems to go into an endless loop.

What? Specific example, please.

> A similar problem I have is with fix precision fields. I want to
> export a numeric(10,2) number from Access but they always end up
> numeric(30,6).

I don't think our 6.5.* ODBC driver knows anything about numeric,
so you're probably going to get default numeric precision if you
go through it. You might have better luck with 7.0.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2000-06-27 08:38:41 Re: Transactions and web applications
Previous Message Karel Zak 2000-06-27 07:45:52 Re: DateTime fields