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: (view raw or whole 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 * * 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-2015 The PostgreSQL Global Development Group