2007/11/7, Hiroshi Inoue <inoue@tpf.co.jp>: Сергей Демьяненко wrote:
> 2007/11/6, Raymond O'Donnell <rod@iol.ie <mailto:rod@iol.ie>>:
>
> On 06/11/2007 14:10, Сергей Демьяненко wrote:
> > When I call TADOQuery.Open stored function raises exception:
> >
> > ERROR: column "arg_last_datetime" doesn't exists.
> > State SQL:42703
> > Context:PL/pgSQL function "deliveries_visits_export3" line 40 at for
> > over select rows
>
> The error message seems to indicate that there's a bug in your pl/pgsql
> function - have you tried calling it directly from psql?
>
> Ray.
>
>
> There is a bit of misunderstanding. Of course I know about bug in the
> procedure. The problem is that TADOQuery doesn't return postgres
> exception because psqlodbsw.dll raises "access violation".
Hmm, psqlodbc 8.2.0500 doesn't include psqlodbcw.dll.
Anyway could yo send me directly the Mylog output ?
regards,
Hiroshi Inoue
I'm sorry. You're right, psqlodbc 8.2.0500 doesn't include psqlodbcw.dll. I installed psqlodbc 8.2.0500 without deinstalling previous version (8.1) so it was the reason of the problem. psqlodbc 8.2.0500 doesn't have described above bug.
Thanx for your efforts.
regards,
Sergei Demyanenko