Обсуждение: timestamp via 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@enter.net
********************************************************************

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mike Fahey
> Sent: 04 October 2004 16:48
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] timestamp via 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 );

I just tested on a 7.3.2 server with psqlOBDC 08.00.0001 & pgAdmin II on
the frontend and it works just fine for me. Can you test with the latest
driver please?

Regards, Dave.