Re: timestamp via odbc - Mailing list pgsql-odbc

From Dave Page
Subject Re: timestamp via odbc
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E43068D7@ratbert.vale-housing.co.uk
Whole thread Raw
In response to timestamp via odbc  (Mike Fahey <mfahey@enter.net>)
List pgsql-odbc

> -----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.

pgsql-odbc by date:

Previous
From: Mike Fahey
Date:
Subject: timestamp via odbc
Next
From: "Scot Loach"
Date:
Subject: bad typenames sent to postgresql server