Re: timestamp via odbc

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Mike Fahey" <mfahey(at)enter(dot)net>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: timestamp via odbc
Date: 2004-10-04 19:56:42
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E43068D7@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Mike Fahey
> Sent: 04 October 2004 16:48
> To: pgsql-odbc(at)postgresql(dot)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.

Browse pgsql-odbc by date

  From Date Subject
Next Message Scot Loach 2004-10-04 21:10:40 bad typenames sent to postgresql server
Previous Message Dave Page 2004-10-04 19:34:18 Re: New snapshot 08.00.0001 uploaded