Skip site navigation (1) Skip section navigation (2)

ODBC driver flakieness

From: "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ODBC driver flakieness
Date: 2001-09-24 22:41:57
Message-ID: E15F4B031E17D5118B18009027F67927DAFE@SERVER (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-odbc
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

Responses

pgsql-hackers by date

Next:From: Daniel A. MorganDate: 2001-09-25 00:37:40
Subject: Re: NewYork Bombing: SQL server bomb proof!!
Previous:From: Patrice HédéDate: 2001-09-24 21:52:04
Subject: Unicode combining characters

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-09-24 23:13:41
Subject: Re: dynasets
Previous:From: Jim HinesDate: 2001-09-24 17:18:56
Subject: Re: dynasets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group