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

Re: Can't use current_timestamp or currval functions

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Mike Fahey <mfahey(at)enter(dot)net>,Postgres list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Can't use current_timestamp or currval functions
Date: 2004-11-10 19:15:58
Message-ID: 20041110191558.70665.qmail@web20828.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- Mike Fahey <mfahey(at)enter(dot)net> wrote:

> I can't call currval() with the odbc driver.
> 
> I'm using odbc driver version 8.0.0.2  with MS
> ACcess 2003.
> 
> I get the following error in access
> 
> run-time error 3085:
> 
> undefined function 'currval' in expression.
> 
> How can i make this work?

You will need to use a pass-through query, if you want
to use Postgresql syntax, functions, operators etc. 
Otherwise, Access assumes that you are attempting to
use an Access function etc.

> 
> Thanks
> 
> 
> 
> 
> 
> 
> 
> -- 
> 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
>
********************************************************************
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 



		
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com 
 


In response to

pgsql-odbc by date

Next:From: Jaime CasanovaDate: 2004-11-10 21:00:49
Subject: Re: ODBC Driver stability
Previous:From: Gary DoadesDate: 2004-11-10 19:15:42
Subject: Re: ODBC Driver stability

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