Two problems (I've been holding back reporting until I ran into this
second):

Background: I'm trying to migrate an existing db from MS Sql 2K to pgsql by
creating a DTS job.

DB system info: NT 4 sp6a, MS SQL2K Regular, Pgsql ODBC driver 7.01.00.06.

First problem: The ODBC driver reports a column of type money in pgsql (and
in ms sql) as float4 and barfs when I try executing the job because the data
is not in the correct format (this is one of, but not the only. reasons why
I am looking for how to change the column datatype).

Second problem: I create a table with a serial column. This table is not in
the existing db and no values are being set.  The job bombs when executed
with a "you don't have permissions to set sequence ..._seq" (why this is
being modified at all I do not know).

In regards to the second problem, if I create a serial column *after* the
damn is imported will all the records be updated?


Geoff

Mon, 24 Sep 2001 18:41:57 -0400
"Gowey, Geoffrey" <ggowey@rxhope.com>
ODBC driver flakieness
Hi Gowey,
Please post to pgsql-odbc list if the problem is ODBC
specific.

"Gowey, Geoffrey" wrote:
> 
> Two problems (I've been holding back reporting until I ran into this
> second):
> 
> Background: I'm trying to migrate an existing db from MS Sql 2K to pgsql by
> creating a DTS job.
> 
> DB system info: NT 4 sp6a, MS SQL2K Regular, Pgsql ODBC driver 7.01.00.06.
> 
> First problem: The ODBC driver reports a column of type money in pgsql (and
> in ms sql) as float4 and barfs when I try executing the job because the data

An example please.

> 
> Second problem: I create a table with a serial column. This table is not in
> the existing db and no values are being set.  The job bombs when executed
> with a "you don't have permissions to set sequence ..._seq" (why this is
> being modified at all I do not know).

Is this an ODBC problem ?
If the e.g. inserting user is different from the one who created
the table, UPDATE permission on the sequence should be granted
as well.

regards,
Hiroshi Inoue

Tue, 25 Sep 2001 10:42:04 +0900
Hiroshi Inoue <Inoue@tpf.co.jp>
Re: ODBC driver flakieness