Обсуждение: Access violation in psqlodbcw.dll

Hello community,

I have a problem with psqlODBC (08.02.05). I'm using Delphi 6 (6.240 UP2), TADOQuery, PostgreSQL 8.2.4.

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

Then TADOQuery raises "destructive exception" and after that any other query executions in my program raise exception "Connection is already in use".

I tryed to execute query in design-time and got "access violation" in psalodbcw.dll

Please help me find out where the problem is.
Thank you.

Regards,
Sergei Demyanenko

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.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

2007/11/6, Raymond O'Donnell <rod@iol.ie>:

Сергей Демьяненко 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