datetime to timestamp

From: "William S(dot) Bear" <bear(at)math(dot)umn(dot)edu>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: datetime to timestamp
Date: 2002-12-27 16:32:57
Message-ID: 1710.128.101.155.245.1041006777.squirrel@staff2.math.umn.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm trying to export an access database to postgres 7.3, but get an error
that datatype datetime does not exist. Noticed in the docs that 7.3 will
not longer support datetime data type. Will the ODBC driver be converting
all datetime datatypes to timestamp in future versions? I've included the
doc snippet and log snippet below.

Thanks,

Will

"To ensure an upgrade path from versions of PostgreSQL earlier than 7.0,
we recognize datetime (equivalent to timestamp) and timespan (equivalent
to interval). These types are now restricted to having an implicit
translation to timestamp and interval, and support for these will be
removed in the next release of PostgreSQL (likely named 7.3)."
-- http://www.postgresql.org/idocs/index.php?datatype-datetime.html

<log snippet>

query='CREATE TABLE "tblCurrentApplicants"("APPLCDATE"
varchar(10),"FOREIGN" char(10),"DOMESTIC" char(10),"LASTNAME"
varchar(50),"FIRSTNAME" varchar(50),"NAME" varchar(100),"Title"
varchar(20),"SEX" varchar(2),"IAP" char(2),"MATHED" char(2),"RATING"
varchar(50),"ADMITMATH" varchar(10),"ADMITGRAD" varchar(10),"GREsubject"
float8,"TOEFL" float8,"MSLET" char(10),"OFFER" varchar(25),"OFFERTYPE"
varchar(25),"DATEOFFER" varchar(10),"INITIALRESPONSE"
varchar(35),"RESPONDUE" varchar(10),"CITIZEN" varchar(50),"ETHNIC"
varchar(50),"BIRTHDATE" varchar(10),"DEGREINST" varchar(50),"INSTADDR"
varchar(50),"DEGREE" varchar(5),"DEGREDATE" varchar(10),"GPA"
varchar(10),"DEGREINST1" varchar(50),"INSTADDR1" varchar(50),"DEGREE1"
varchar(5),"DEGREDATE1" varchar(10),"GPA1" varchar(10),"INTEREST"
varchar(254),"VISA" varchar(50),"PRESADDR1" varchar(50),"PRESADDR2"
varchar(50),"PRESADDR3" varchar(50),"ADVISOR" varchar(50),"COMMENTS"
varchar(254),"Selected" char(254),"FINALRESPONSE" varchar(50),"ACTUARY"
char(50),"GREquantitative" int4,"GREanalytical" int4,"GREverbal"
int4,"Rejectletter" datetime,"email" varchar(254),"recdatet1"
datetime,"recauth1" varchar(254),"recdate2" datetime,"recauth2"
varchar(254),"recdate3" datetime,"recauth3" varchar(254),"purposedate"
datetime,"gredate" datetime,"toefldate" datetime)'
ERROR from backend during send_query: 'ERROR: Type "datetime" does not
exist'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while
executing the query'
------------------------------------------------------------
hdbc=262500944, stmt=262538944, result=262538704
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=4, statement='CREATE TABLE
"tblCurrentApplicants"("APPLCDATE" varchar(10),"FOREIGN"
char(10),"DOMESTIC" char(10),"LASTNAME"
varchar(50),"FIRSTNAME" varchar(50),"NAME"
varchar(100),"Title" varchar(20),"SEX" varchar(2),"IAP"
char(2),"MATHED" char(2),"RATING" varchar(50),"ADMITMATH"
varchar(10),"ADMITGRAD" varchar(10),"GREsubject"
float8,"TOEFL" float8,"MSLET" char(10),"OFFER"
varchar(25),"OFFERTYPE" varchar(25),"DATEOFFER"
varchar(10),"INITIALRESPONSE" varchar(35),"RESPONDUE"
varchar(10),"CITIZEN" varchar(50),"ETHNIC"
varchar(50),"BIRTHDATE" varchar(10),"DEGREINST"
varchar(50),"INSTADDR" varchar(50),"DEGREE"
varchar(5),"DEGREDATE" varchar(10),"GPA"
varchar(10),"DEGREINST1" varchar(50),"INSTADDR1"
varchar(50),"DEGREE1" varchar(5),"DEGREDATE1"
varchar(10),"GPA1" varchar(10),"INTEREST"
varchar(254),"VISA" varchar(50),"PRESADDR1"
varchar(50),"PRESADDR2" varchar(50),"PRESADDR3"
varchar(50),"ADVISOR" varchar(50),"COMMENTS"
varchar(254),"Selected" char(254),"FINALRESPONSE"
varchar(50),"ACTUARY" char(50),"GREquantitative"
int4,"GREanalytical" int4,"GREverbal" int4,"Rejectletter"
datetime,"email" varchar(254),"recdatet1"
datetime,"recauth1" varchar(254),"recdate2"
datetime,"recauth2" varchar(254),"recdate3"
datetime,"recauth3" varchar(254),"purposedate"
datetime,"gredate" datetime,"toefldate" datetime)'
stmt_with_params='CREATE TABLE
"tblCurrentApplicants"("APPLCDATE" varchar(10),"FOREIGN"
char(10),"DOMESTIC" char(10),"LASTNAME"
varchar(50),"FIRSTNAME" varchar(50),"NAME"
varchar(100),"Title" varchar(20),"SEX" varchar(2),"IAP"
char(2),"MATHED" char(2),"RATING" varchar(50),"ADMITMATH"
varchar(10),"ADMITGRAD" varchar(10),"GREsubject"
float8,"TOEFL" float8,"MSLET" char(10),"OFFER"
varchar(25),"OFFERTYPE" varchar(25),"DATEOFFER"
varchar(10),"INITIALRESPONSE" varchar(35),"RESPONDUE"
varchar(10),"CITIZEN" varchar(50),"ETHNIC"
varchar(50),"BIRTHDATE" varchar(10),"DEGREINST"
varchar(50),"INSTADDR" varchar(50),"DEGREE"
varchar(5),"DEGREDATE" varchar(10),"GPA"
varchar(10),"DEGREINST1" varchar(50),"INSTADDR1"
varchar(50),"DEGREE1" varchar(5),"DEGREDATE1"
varchar(10),"GPA1" varchar(10),"INTEREST"
varchar(254),"VISA" varchar(50),"PRESADDR1"
varchar(50),"PRESADDR2" varchar(50),"PRESADDR3"
varchar(50),"ADVISOR" varchar(50),"COMMENTS"
varchar(254),"Selected" char(254),"FINALRESPONSE"
varchar(50),"ACTUARY" char(50),"GREquantitative"
int4,"GREanalytical" int4,"GREverbal" int4,"Rejectletter"
datetime,"email" varchar(254),"recdatet1"
datetime,"recauth1" varchar(254),"recdate2"
datetime,"recauth2" varchar(254),"recdate3"
datetime,"recauth3" varchar(254),"purposedate"
datetime,"gredate" datetime,"toefldate" datetime)'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR0FA606C0'
----------------QResult Info -------------------------------
fields=262538912, manual_tuples=0, backend_tuples=0,
tupleField=0, conn=0
fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
message='(NULL)', command='(NULL)', notice='(NULL)'
status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: Type
"datetime" does not exist'

</log snippet>

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-12-28 00:24:58 Re: Crash when calling SQLSetDescField
Previous Message jaydip rathod 2002-12-27 05:21:47 help