ok i brought it in as varchar and cast as date.
On Sun, Mar 22, 2009 at 12:27 PM, zach cruise zachc1...@gmail.com wrote:
On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
zach cruise wrote:
when importing from oracle 10g
Importing how? CSV dump and load? DB
zach cruise wrote:
when importing from oracle 10g
Importing how? CSV dump and load? DB link of some sort?
Operating system and version? Oracle version?
i get multiple step ole db generated
error.
From what program ? Where?
--
Craig Ringer
--
Sent via pgsql-general mailing list
On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
zach cruise wrote:
when importing from oracle 10g
Importing how? CSV dump and load? DB link of some sort?
odbc (see email) specifically Microsoft OLE DB Provider for Oracle
Operating system and version? Oracle
when importing from oracle 10g, i get multiple step ole db generated
error. i narrowed this down to a date/timestamp column - actually to
about 100 rows within that column, all = '01-JAN-01' (never null).
there is another date/timestamp column that gets imported error-free,
and other tables also