Access violation in psqlodbcw.dll

------=_Part_26123_31595874.1194358220872
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_26123_31595874.1194358220872
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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


------=_Part_26123_31595874.1194358220872--

Re: Access violation in psqlodbcw.dll

On 06/11/2007 14:10, Сергей Де=D0=
¼ÑŒÑÐ½ÐµÐ½ÐºÐ=BE wrote:
> When I call TADOQuery.Open stored function raises exception:
>=20
> ERROR: column "arg_last_datetime" doesn't exists.
> State SQL:42703
> Context:PL/pgSQL function "deliveries_visits_export3" line 40 at for=20
> over select rows

The error message seems to indicate that there's a bug in your pl/pgsql=20
function - have you tried calling it directly from psql?

Ray.

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Access violation in psqlodbcw.dll

------=_Part_30308_24197653.1194421724115
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: base64
Content-Disposition: inline

MjAwNy8xMS82LCBSYXltb25kIE8nRG9ubmVsbCA8cm9kQGlvbC5pZT46Cj4K PiBPbiAwNi8xMS8y
MDA3IDE0OjEwLCDzxdLHxcog5MXN2NHOxc7LzyB3cm90ZToKPiA+IFdoZW4g SSBjYWxsIFRBRE9R
dWVyeS5PcGVuIHN0b3JlZCBmdW5jdGlvbiByYWlzZXMgZXhjZXB0aW9uOgo+ ID4KPiA+IEVSUk9S
OiBjb2x1bW4gImFyZ19sYXN0X2RhdGV0aW1lIiBkb2Vzbid0IGV4aXN0cy4K PiA+IFN0YXRlIFNR
TDo0MjcwMwo+ID4gQ29udGV4dDpQTC9wZ1NRTCBmdW5jdGlvbiAiZGVsaXZl cmllc192aXNpdHNf
ZXhwb3J0MyIgbGluZSA0MCBhdCBmb3IKPiA+IG92ZXIgc2VsZWN0IHJvd3MK Pgo+IFRoZSBlcnJv
ciBtZXNzYWdlIHNlZW1zIHRvIGluZGljYXRlIHRoYXQgdGhlcmUncyBhIGJ1 ZyBpbiB5b3VyIHBs
L3Bnc3FsCj4gZnVuY3Rpb24gLSBoYXZlIHlvdSB0cmllZCBjYWxsaW5nIGl0 IGRpcmVjdGx5IGZy
b20gcHNxbD8KPgo+IFJheS4KPgoKVGhlcmUgaXMgYSBiaXQgb2YgbWlzdW5k ZXJzdGFuZGluZy4g
T2YgY291cnNlIEkga25vdyBhYm91dCBidWcgaW4gdGhlCnByb2NlZHVyZS4g VGhlIHByb2JsZW0g
aXMgdGhhdCBUQURPUXVlcnkgZG9lc24ndCByZXR1cm4gcG9zdGdyZXMgZXhj ZXB0aW9uCmJlY2F1
c2UgcHNxbG9kYnN3LmRsbCByYWlzZXMgImFjY2VzcyB2aW9sYXRpb24iLgoK UmVnYXJkcywgU2Vy
Z2VpIERlbXlhbmVua28K
------=_Part_30308_24197653.1194421724115
Content-Type: text/html; charset=KOI8-R
Content-Transfer-Encoding: base64
Content-Disposition: inline

MjAwNy8xMS82LCBSYXltb25kIE8mIzM5O0Rvbm5lbGwgJmx0OzxhIGhyZWY9 Im1haWx0bzpyb2RA
aW9sLmllIj5yb2RAaW9sLmllPC9hPiZndDs6PGRpdj48c3BhbiBjbGFzcz0i Z21haWxfcXVvdGUi
Pjwvc3Bhbj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxl PSJib3JkZXItbGVm
dDogMXB4IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgbWFyZ2luOiAwcHQg MHB0IDBwdCAwLjhl
eDsgcGFkZGluZy1sZWZ0OiAxZXg7Ij4KT24gMDYvMTEvMjAwNyAxNDoxMCwg 88XSx8XKIOTFzdjR
zsXOy88gd3JvdGU6PGJyPiZndDsgV2hlbiBJIGNhbGwgVEFET1F1ZXJ5Lk9w ZW4gc3RvcmVkIGZ1
bmN0aW9uIHJhaXNlcyBleGNlcHRpb246PGJyPiZndDs8YnI+Jmd0OyBFUlJP UjogY29sdW1uICZx
dW90O2FyZ19sYXN0X2RhdGV0aW1lJnF1b3Q7IGRvZXNuJiMzOTt0IGV4aXN0 cy48YnI+Jmd0OyBT
dGF0ZSBTUUw6NDI3MDM8YnI+CiZndDsgQ29udGV4dDpQTC9wZ1NRTCBmdW5j dGlvbiAmcXVvdDtk
ZWxpdmVyaWVzX3Zpc2l0c19leHBvcnQzJnF1b3Q7IGxpbmUgNDAgYXQgZm9y PGJyPiZndDsgb3Zl
ciBzZWxlY3Qgcm93czxicj48YnI+VGhlIGVycm9yIG1lc3NhZ2Ugc2VlbXMg dG8gaW5kaWNhdGUg
dGhhdCB0aGVyZSYjMzk7cyBhIGJ1ZyBpbiB5b3VyIHBsL3Bnc3FsPGJyPmZ1 bmN0aW9uIC0gaGF2
ZSB5b3UgdHJpZWQgY2FsbGluZyBpdCBkaXJlY3RseSBmcm9tIHBzcWw/Cjxi cj48YnI+UmF5Ljxi
cj48L2Jsb2NrcXVvdGU+PGRpdj4mbmJzcDs8L2Rpdj5UaGVyZSBpcyBhIGJp dCBvZiBtaXN1bmRl
cnN0YW5kaW5nLiBPZiBjb3Vyc2UgPHNwYW4gY2xhc3M9ImdtYWlsX3F1b3Rl Ij48L3NwYW4+SSBr
bm93IGFib3V0IGJ1ZyBpbiB0aGUgcHJvY2VkdXJlLiBUaGUgcHJvYmxlbSBp cyB0aGF0IFRBRE9R
dWVyeSBkb2VzbiYjMzk7dCByZXR1cm4gcG9zdGdyZXMgZXhjZXB0aW9uIGJl Y2F1c2UgCnBzcWxv
ZGJzdy5kbGwgcmFpc2VzICZxdW90O2FjY2VzcyB2aW9sYXRpb24mcXVvdDsu PGJyPjxicj5SZWdh
cmRzLCBTZXJnZWkgRGVteWFuZW5rbzxicj48L2Rpdj4K
------=_Part_30308_24197653.1194421724115--

Re: Access violation in psqlodbcw.dll

óÅÒÇÅÊ äÅÍØÑÎÅÎËÏ wrote:
> 2007/11/6, Raymond O'Donnell >:
>=20
> On 06/11/2007 14:10, óÅÒÇÅÊ äÅÍØÑÎÅÎ=CB=
=CF 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
>=20
> The error message seems to indicate that there's a bug in your pl/p=
gsql
> function - have you tried calling it directly from psql?
>=20
> Ray.
>=20
> =20
> There is a bit of misunderstanding. Of course I know about bug in the=20
> procedure. The problem is that TADOQuery doesn't return postgres=20
> 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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Access violation in psqlodbcw.dll

------=_Part_35848_10492858.1194512088456
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: base64
Content-Disposition: inline

MjAwNy8xMS83LCBIaXJvc2hpIElub3VlIDxpbm91ZUB0cGYuY28uanA+Ogo+ Cj4g88XSx8XKIOTF
zdjRzsXOy88gd3JvdGU6Cj4gPiAyMDA3LzExLzYsIFJheW1vbmQgTydEb25u ZWxsIDxyb2RAaW9s
LmllIDxtYWlsdG86cm9kQGlvbC5pZT4+Ogo+ID4KPiA+ICAgICBPbiAwNi8x MS8yMDA3IDE0OjEw
LCDzxdLHxcog5MXN2NHOxc7LzyB3cm90ZToKPiA+ICAgICAgPiBXaGVuIEkg Y2FsbCBUQURPUXVl
cnkuT3BlbiBzdG9yZWQgZnVuY3Rpb24gcmFpc2VzIGV4Y2VwdGlvbjoKPiA+ ICAgICAgPgo+ID4g
ICAgICA+IEVSUk9SOiBjb2x1bW4gImFyZ19sYXN0X2RhdGV0aW1lIiBkb2Vz bid0IGV4aXN0cy4K
PiA+ICAgICAgPiBTdGF0ZSBTUUw6NDI3MDMKPiA+ICAgICAgPiBDb250ZXh0 OlBML3BnU1FMIGZ1
bmN0aW9uICJkZWxpdmVyaWVzX3Zpc2l0c19leHBvcnQzIiBsaW5lIDQwIGF0 Cj4gZm9yCj4gPiAg
ICAgID4gb3ZlciBzZWxlY3Qgcm93cwo+ID4KPiA+ICAgICBUaGUgZXJyb3Ig bWVzc2FnZSBzZWVt
cyB0byBpbmRpY2F0ZSB0aGF0IHRoZXJlJ3MgYSBidWcgaW4geW91cgo+IHBs L3Bnc3FsCj4gPiAg
ICAgZnVuY3Rpb24gLSBoYXZlIHlvdSB0cmllZCBjYWxsaW5nIGl0IGRpcmVj dGx5IGZyb20gcHNx
bD8KPiA+Cj4gPiAgICAgUmF5Lgo+ID4KPiA+Cj4gPiBUaGVyZSBpcyBhIGJp dCBvZiBtaXN1bmRl
cnN0YW5kaW5nLiBPZiBjb3Vyc2UgSSBrbm93IGFib3V0IGJ1ZyBpbiB0aGUK PiA+IHByb2NlZHVy
ZS4gVGhlIHByb2JsZW0gaXMgdGhhdCBUQURPUXVlcnkgZG9lc24ndCByZXR1 cm4gcG9zdGdyZXMK
PiA+IGV4Y2VwdGlvbiBiZWNhdXNlIHBzcWxvZGJzdy5kbGwgcmFpc2VzICJh Y2Nlc3MgdmlvbGF0
aW9uIi4KPgo+IEhtbSwgcHNxbG9kYmMgOC4yLjA1MDAgZG9lc24ndCBpbmNs dWRlIHBzcWxvZGJj
dy5kbGwuCj4gQW55d2F5IGNvdWxkIHlvIHNlbmQgbWUgZGlyZWN0bHkgdGhl IE15bG9nIG91dHB1
dCA/Cj4KPiByZWdhcmRzLAo+IEhpcm9zaGkgSW5vdWUKPgo+Cj4KSSdtIHNv cnJ5LiBZb3UncmUg
cmlnaHQsIHBzcWxvZGJjIDguMi4wNTAwIGRvZXNuJ3QgaW5jbHVkZSBwc3Fs b2RiY3cuZGxsLiBJ
Cmluc3RhbGxlZCBwc3Fsb2RiYyA4LjIuMDUwMCB3aXRob3V0IGRlaW5zdGFs bGluZyBwcmV2aW91
cyB2ZXJzaW9uICg4LjEpIHNvCml0IHdhcyB0aGUgcmVhc29uIG9mIHRoZSBw cm9ibGVtLiBwc3Fs
b2RiYyA4LjIuMDUwMCBkb2Vzbid0IGhhdmUgZGVzY3JpYmVkCmFib3ZlIGJ1 Zy4KClRoYW54IGZv
ciB5b3VyIGVmZm9ydHMuCgpyZWdhcmRzLApTZXJnZWkgRGVteWFuZW5rbwo=
------=_Part_35848_10492858.1194512088456
Content-Type: text/html; charset=KOI8-R
Content-Transfer-Encoding: base64
Content-Disposition: inline

PGJyPjxicj48ZGl2PjxzcGFuIGNsYXNzPSJnbWFpbF9xdW90ZSI+MjAwNy8x MS83LCBIaXJvc2hp
IElub3VlICZsdDs8YSBocmVmPSJtYWlsdG86aW5vdWVAdHBmLmNvLmpwIj5p bm91ZUB0cGYuY28u
anA8L2E+Jmd0Ozo8L3NwYW4+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1 b3RlIiBzdHlsZT0i
Ym9yZGVyLWxlZnQ6IDFweCBzb2xpZCByZ2IoMjA0LCAyMDQsIDIwNCk7IG1h cmdpbjogMHB0IDBw
dCAwcHQgMC44ZXg7IHBhZGRpbmctbGVmdDogMWV4OyI+CvPF0sfFyiDkxc3Y 0c7FzsvPIHdyb3Rl
Ojxicj4mZ3Q7IDIwMDcvMTEvNiwgUmF5bW9uZCBPJiMzOTtEb25uZWxsICZs dDs8YSBocmVmPSJt
YWlsdG86cm9kQGlvbC5pZSI+cm9kQGlvbC5pZTwvYT4gJmx0O21haWx0bzo8 YSBocmVmPSJtYWls
dG86cm9kQGlvbC5pZSI+cm9kQGlvbC5pZTwvYT4mZ3Q7Jmd0Ozo8YnI+Jmd0 Ozxicj4mZ3Q7Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IE9uIDA2LzExLzIwMDcgMTQ6MTAsIPPF 0sfFyiDkxc3Y0c7F
zsvPIHdyb3RlOgo8YnI+Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZn
dDsgV2hlbiBJIGNhbGwgVEFET1F1ZXJ5Lk9wZW4gc3RvcmVkIGZ1bmN0aW9u IHJhaXNlcyBleGNl
cHRpb246PGJyPiZndDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmZ3Q7PGJy
PiZndDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmZ3Q7 IEVSUk9SOiBjb2x1
bW4gJnF1b3Q7YXJnX2xhc3RfZGF0ZXRpbWUmcXVvdDsgZG9lc24mIzM5O3Qg ZXhpc3RzLjxicj4m
Z3Q7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jmd0OyBT dGF0ZSBTUUw6NDI3
MDM8YnI+Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZndDsgQ29udGV4
dDpQTC9wZ1NRTCBmdW5jdGlvbiAmcXVvdDtkZWxpdmVyaWVzX3Zpc2l0c19l eHBvcnQzJnF1b3Q7
IGxpbmUgNDAgYXQgZm9yCjxicj4mZ3Q7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5i
c3A7Jmd0OyBvdmVyIHNlbGVjdCByb3dzPGJyPiZndDs8YnI+Jmd0OyZuYnNw OyZuYnNwOyZuYnNw
OyZuYnNwOyBUaGUgZXJyb3IgbWVzc2FnZSBzZWVtcyB0byBpbmRpY2F0ZSB0 aGF0IHRoZXJlJiMz
OTtzIGEgYnVnIGluIHlvdXIgcGwvcGdzcWw8YnI+Jmd0OyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNw
OyBmdW5jdGlvbiAtIGhhdmUgeW91IHRyaWVkIGNhbGxpbmcgaXQgZGlyZWN0 bHkgZnJvbSBwc3Fs
Pzxicj4mZ3Q7PGJyPiZndDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgUmF5 Lgo8YnI+Jmd0Ozxi
cj4mZ3Q7PGJyPiZndDsgVGhlcmUgaXMgYSBiaXQgb2YgbWlzdW5kZXJzdGFu ZGluZy4gT2YgY291
cnNlIEkga25vdyBhYm91dCBidWcgaW4gdGhlPGJyPiZndDsgcHJvY2VkdXJl LiBUaGUgcHJvYmxl
bSBpcyB0aGF0IFRBRE9RdWVyeSBkb2VzbiYjMzk7dCByZXR1cm4gcG9zdGdy ZXM8YnI+Jmd0OyBl
eGNlcHRpb24gYmVjYXVzZSBwc3Fsb2Ric3cuZGxsIHJhaXNlcyAmcXVvdDth Y2Nlc3MgdmlvbGF0
aW9uJnF1b3Q7Lgo8YnI+PGJyPkhtbSwgcHNxbG9kYmMgOC4yLjA1MDAgZG9l c24mIzM5O3QgaW5j
bHVkZSBwc3Fsb2RiY3cuZGxsLjxicj5Bbnl3YXkgY291bGQgeW8gc2VuZCBt ZSBkaXJlY3RseSB0
aGUgTXlsb2cgb3V0cHV0ID88YnI+PGJyPnJlZ2FyZHMsPGJyPkhpcm9zaGkg SW5vdWU8YnI+PGJy
Pjxicj48L2Jsb2NrcXVvdGU+PC9kaXY+PGJyPkkmIzM5O20gc29ycnkuIFlv dSYjMzk7cmUgcmln
aHQsIHBzcWxvZGJjIAo4LjIuMDUwMCBkb2VzbiYjMzk7dCBpbmNsdWRlIHBz cWxvZGJjdy5kbGwu
IEkgaW5zdGFsbGVkIHBzcWxvZGJjIDguMi4wNTAwIHdpdGhvdXQgZGVpbnN0 YWxsaW5nIHByZXZp
b3VzIHZlcnNpb24gKDguMSkgc28gaXQgd2FzIHRoZSByZWFzb24gb2YgdGhl IHByb2JsZW0uIHBz
cWxvZGJjIDguMi4wNTAwIGRvZXNuJiMzOTt0IGhhdmUgZGVzY3JpYmVkIGFi b3ZlIGJ1Zy48YnI+
PGJyPlRoYW54IGZvciB5b3VyIGVmZm9ydHMuCjxicj48YnI+cmVnYXJkcyw8 YnI+U2VyZ2VpIERl
bXlhbmVua288YnI+PGJyPgo=
------=_Part_35848_10492858.1194512088456--