RS] 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.
Just go into MS SQL and try creating a DTS job to migrate from MS SQL to
Pgsql. Have both fields (in ms and pg) be of type money. In the
destination the field type will show up as float4 instead of money. If you
try executing the job it will bomb saying that it is sending data in the
wrong format (or something to that effect [i forget]).
>
> >
> > 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.
I don't know. The table does not exist at all in the db that I'm migrating
from (so why it's being touched at all I don't know). Also, I created the
column with one user and am importing the table with another user as the
odbc login, but that whole table is rwx for that user. Did I miss
something?
>
> regards,
> Hiroshi Inoue
>
