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

timestamp via odbc

From: Mike Fahey <mfahey(at)enter(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: timestamp via odbc
Date: 2004-10-04 15:48:20
Message-ID: 416170C4.5020304@enter.net (view raw or flat)
Thread:
Lists: pgsql-odbc
The following table structure does not work when using the odbc driver.

It's because of the column default current_timestamp.
If i remove the default current_timestamp it works fine.

Is this not implemented or is this a bug


create table mytable(
id serial,
myname varchar(100),
thetime timestamp default current_timestamp
);

-- 
With best regards,

Mike Fahey - Systems Administration
********************************************************************
      ENTER.NET - "The Road to the Internet Starts Here!" (tm)
  (610) 437-2221 * http://www.enter.net/ * email:support(at)enter(dot)net
********************************************************************


pgsql-odbc by date

Next:From: Gary DoadesDate: 2004-10-04 18:58:40
Subject: Re: New snapshot 08.00.0001 uploaded
Previous:From: Peter van HeckDate: 2004-10-04 14:21:18
Subject: Re: ERROR: invalid input syntax for type boolean: "-"(#7)

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