Out of memory error

Out of memory error

am 02.10.2007 01:48:45 von Mike.Relyea

This is a multi-part message in MIME format.

------_=_NextPart_001_01C80485.9C128E14
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Repost with zipped attachment. First post never showed up?

> I'm receiving an out of memory error when trying to execute a=20
> long, complex query involving many temp tables. I'm using=20
> psqlODBC ver 8.02.0500 and PG 8.2.4 on WinXP. I'm trying to=20
> execute this query via a pass-through query in MS Access=20
> 2003. If I execute this query in PGAdmin III it runs without=20
> any errors and returns no records.
>=20
> My connection string in Access is:
> ODBC; DRIVER=3D{PostgreSQL Unicode}; SERVER=3DmyServer;=20
> DATABASE=3Diqdb; PORT=3D5432; UID=3DmyUserName; PWD=3Dxxxxxxx; B9=3D0;=20
> B7=3D1; B3=3D1; C8=3D1
>=20
> I've attached the log file which contains the SQL I'm trying=20
> to execute and the error details. I've tried setting=20
> UseDeclareFetch =3D 1 but it didn't resolve the error. Any=20
> suggestions?

------_=_NextPart_001_01C80485.9C128E14
Content-Type: application/x-zip-compressed;
name="psqlodbc_3888.zip"
Content-Transfer-Encoding: base64
Content-Description: psqlodbc_3888.zip
Content-Disposition: attachment;
filename="psqlodbc_3888.zip"

UEsDBBQAAAAIADljQTctnWvZKRUAAAMTAQARAAAAcHNxbG9kYmNfMzg4OC5s
b2ftXW1v4sqS/h4p/6EVaUWyYpANJIHJ9ZUIkAyrQDJAcvbu0REydgd8xi+M
XzLJWe397VvdfrexwSbJhDPNl+B+eapcXU912bGL37ka1+D/6JnKEzbRAzYt
xdCFCteqcfUad8px1TrHnXNtHv5wfAWpiv5N0ReIb/AcsmzRViQ0dFRbsZcm
FmXon5ui+XJ48LsLfK0ac1FFtysbcK3P6BHb0lLgARdZhvQN20KTa59VkaN/
040f+sxS/sKWAL2a+Dx7Ek1pKZq0UaifnrqtqqEvYj0tvs0FAlHiIyuWOFfx
zAANNBhtCnwVfbO+G+SvoyvfHTxTdBk/02MLz2QsqaKJXUWzcW38bM9EK6qN
i0jPw0p2wRnNDUOl7W4DGnWG/V5n2rnpj4SzZqYgkGOKM+sFjE3OYwWqKc9g
o4oszy4qVSQZOpgN2zYsC7RW3AasS4YMLdBAkfmmi/w7ujMse2Hiydcb9OQu
N6yjSdZUQJVWrV5rVtAfm+fojjYHj3HnRGcQ8QLX6vUa7dNWFYF9zRehYmEV
SzYyFLmK7JfVXASNX1YYPZqGhlaLGT34scQmJt26qGECrRq++qdnnip0XbCM
OGQaPyxfbtB9I5oLjG7nf3rSAOVTu91OjeuqCtZt5JuJCLufXrUq6BgaiOyz
k8icxDndXXfuBjOXM13oAlnHhmOfCJXeePDQHwv/GzHYva4QyP+7IGt92Zn0
BeW7PL+Y9MdkpPYywSbAXNzdjqfCabNRv7gf9KD53sLmCMxwcfdbT3gOPhfd
jiBfdM6Ei845odFFp0UZdHHJEYZcXPKUDheXA4G76NYF4iQX3f8W+Hmd47nz
+fyiwwvnteZF5xKmX7jWrXONjGWb9G/63SmCk3xUFlWkP4iqg9HV+HaIhpMX
i7R7EI3mH/3x+HbsruhcBG7rMpId6lkWfJ9RyM8IMMm4wtO6zfodRKCi04Ym
VkUSfNCRBiSC03w8QrKBLaQbsP7PimUXxrwi/mmtRAnXpMKTb+r14mcxHov6
Aj+I5jW2x1hV5BBhMu1M+8P+aIooFoRYR5eESXeGn7Hk2LiKZGxJQuVYd1T1
BAIGNk0gr3BOv2kWhIi+aRomsE9RMXJnEQXsJXbdIJSVjE3o0w6fbNSlPJci
vmjZmk0P2xwHhya2YMNxG+oNLhsGQuUKIjmJvYpuY1MXVSFn+By2ARpDOe9T
DZpmoqoakmhjOQ8AhIFfgKAoRNi4HQjZU7EGsYmGRKJ70FKQjmugNXv2A3bq
GVXK2hVPFm1xJtrU0YRPsPlJjmkSzUmDK4M2rxx7RsbmnTaZOnVWKo4BSYZK
jyGJ+HP2KMP3bARIDcawIxCLkZ0B225yQHZ7/BIcchTcMszQvJJpqCqI0l2p
0ouQI8WbTAIAmO/rzax7P/ZdswBPvo6pE6OB/mhsIlE26qOCVdnymHBF/NUN
ITObWDLqhbThigynFqCx3vvkwJOtFgzjgOvBLAgaM9uwRXVmenYmLb4Ovl0h
0Izub25OcowBsdMSF2A/L2BtEaGJzpom6nIAXyW9ioS3kEcI5Fgk4Cn61LNM
MLp7OxoVjJw8z0Vi59bnsFbBDWuf+1kLuMT6kxc76y1/qSOhlJqCd9eOBAQ4
OFsLRNJzOvOs2eHcIOy6Wuv0vOVRknKI5FdbnRua0Iy/vNN7VwztxhnZBUgm
ShmMyfbl5qPBIV2bPM+YO4+P2ITUX+CbrfP6Od9sVv1GyOVoa4OvN1t5sx8V
VcUyATmrJtoIBhc0kmsjOoyiNdob0mSpBv60FC3TAWetuodw2SVXgx5Iba0g
eYZNRVSNRQ2+BpkJcqqJLrissSwkeVm2U3OzYwoYzgKKhU0kK7bnKoS5ib8H
WRU6xKnpVpClr5y5qkhepn7KJzN1Ppqpg+/kn7ruI1dDPapIrIm2HfkKjkev
JGrexYI/wtG8byrWw6GaIfsDDJuQuZprYXqRItdE2TIl18bHx8frbalA8m+i
Pw1Fz1wHHZGrpW2srSrfcJbBA7N4ozybn2RrAGdrKnMIY0gkGhyTQERtoFiy
aaxWWD6hyL7h0D/hmipoMEmSSRUGxXOk0Os2mwiwvVMM1+cEqfgR+kCHcC7B
lvEjkskcOhZWgTQQ0cTovuSIGn4X0VIIFTYAyETzlyyfoaNcrzyHK5y4Vzai
Xkm63Yu6rqE6GrlRQa+2hfRqVOmGFyYAg16lSsNgvVF1GyHXbFZ2gv1uvpBL
Pw+Y55o+tHc3YTd0uNqHXl/rUw+a3M9wcVunbUbRogFRXxMQGTm3IydxuBxy
ku4yfr6BnGVhtyNnWfSdyRmxsVIDtsDFj/dNsdzbncGhpDoWrD52madF1ihk
XWz1iA+tyTno7VOkZOQb65vlZLOoITHZFmWom7XI5ZjodbgckNMEl70uapjQ
rekhfo7RLQwIouvvpC1wds+yK1PRRPOFXj+krL+OEGRx+RqXlzvxNb6VlTt5
1/FHrvccIfcS/sg9+6PaUdJSR+i3L/1xHx0fed58RIwF36fYskeOBqY8Qa5O
dT5JzphOp42sVNbTqTeYTAcjohwoQeBJ9m9q9GIJNBuK0lLR8aB3VKUjrkRN
URVsQRf9+pJuvzOBxNZAB2IZZrq76947ODo8oEY4XicXDUaj/hj91+1gRKd3
RRPisbzAU6AdWOd2lKFubCAoDWZbMz897iQpMVDYl5WCcE8/lJGyDHQdHtyP
Brejw4OUsamRJqJGrnbfzcxJM970r6avfconaDy4/uLBHsfPMyEwtepEbqZh
PJl5LnqSqXmGX2x2IHoHvl47bZ4nWdZsNUOi1Vs1juPemv1DQzcmjkZClx8A
iOAGnx0BvP4PqRjPZe2V3XG/M+2jaX94h6ady5s+OppibTWjztE1VtQHOxOU
plWSS3c+U/xZHh8SjgnjDg/8k7tL+l2T5zh0O07Ckx6u3T5BF4cHhwdZOvew
bin2S1TfzWpW0fj2ftQ77jxcgz4PpNe/T03vAR+dfP48uh/2x4NuFdVPCPaR
L+jwAGWeoke+nrJQYBcfaOKCdvUGHvl8NdxZHlGgN9kcIEWaO7qovliuqEnH
BaRTqRgPi/SELQHMEIuWY/pedjT01KGDV5boTR4GR6H8mFmo7Ad3MhkcgfXl
P6Sa01jEtSnUyNMjtgA+0ijRGOC4hlCsoSE7ruk7w6hOEGAkD6QTawkQpuS/
pNQS03Ci2+hNnEYbYF5p30WdUc/tJMHwDvJ+bOqU258/k7QW/fvfqDL42rn6
NL3jz/+j4rXSWVT7+NlGZ0Js6Fxdm6Kig0zLik49jpxAYsqkAYGB8wcTzTOH
TpvcZHmpitK3rYc/RYefeCcfW8nEJNllVcebAqa+Bmreoct/oQSFI/TNDQj3
ukJ2nDIxwXB0+fh4KD4fp+LBp6Gip1tJmHA0DO5V9aJERDoLFCxQsEDxHoFi
I7dzA8YlKLIwCfeLBgw66Ris9Pmz7oYB9AmJT4vMnMIbFeQUoejZzX+ygMEC
RuGAsZ5kJFaEvlU0WPSwaov92KRcasKq6DdWfHzBOPaKdL5eGpZdjska3fk3
XA7wLnVdMYyye0zZAh5XzeZNdb23V9eSBqR+6TwMRtelGZ/to+gf/0SwE8mG
M1cxefpLUuijqu4+v5n2g689/Igl+1KkT31Ft/LNk0Fd0wiT38TGvlU0iCc1
x/kx524Jqkii2gE2KLYj46i6uTMpceH8kjNPcqPKw+XkAZs2EVk0thS41eDF
FhA2C6SxELPHIeYnZQXZBCB8i/hywcxgPcuLkLz1Bjs+nM8Xw1T+MnT7vdgZ
kcf4yfj56vwM/etvwdChQZ53eXtqenIYJX9BShbw1Q3ZfJqcGTn+7tn8Fowe
Da+2vxRPDS5G+VwSjxztt6Vi48nKIAvzqlwOqHziEnnkvl5nPCJVWSxtZFGZ
jNe/IK933GoJvmZpU3FBeiqhB1e25J87eHsGUs9dM6kYE4sFtFzedkwsvhlx
1/yjfEpekkEiSGX8ZfzdN/5S7yWU+SDshXhC/1X2JuRNbrayaH5jXGVcfR2u
hn77Rlz9mHvt29F1017L6Mvou0f0/Whb7cNYXCywTJ6ReUPm+neRvTvw6AZg
LdSXFxhF5DP+Mv4W5e92zCn+8Bjx0K+OqCbuJ2c9O0ZkTdpPNf5iZQTRIPeB
MDK6Hhm98XkwIiIkyxuEgi/vGQrCm/0sGLBgsDkYcGf19cGg0eK5Qo9cvFMs
WBaKBcsPFgsevvQm03JRoMgDZUFCQMUxyjPKf5T9nzhkbEo21+mj3bW4gNxr
gAj2K1L2y/tQNrJxM9Iy0u4zaZc/n7T/InUgYqSdDhKAIK3bmfRdq4/i7yKT
F41heP/25g5cvEvKth2hwQSNbqeIFMJCUzKlMMI/BKSRV7+6Q2oQv/3EheMA
qH8z6W8B9Gk9DgEY9XwYzj2k0cW1RxBT1r3RTSwEA+LvfXcNTTP0BK+7Hg8S
JiUOTTUKm9J4sdPKQllz/lFMnyXpmQFN1nRRnhwehB6W8oiNdqcul+lQ9B1s
Z7VSFWxa0Od/z0CeGnpmX890tIyuu+44axJ+wurYUNUc2EtVlHFG72/KCucO
6C6VlddFieieJuUzdTKv0RvyP3B+pJ/89ZqIz/mv+fvfSVfqhfHkdnoUez27
Frw/7fdE3pSsRV+b9Psjr2XVEi9K+UPcdzBq3rsYfmv8cdBa8nnNyLDgGeta
/JFrf4j3OFnNf67Mb48/CVPLeFrFH534/3st5x/kEQGR/yJEBURu8UfxY6Mz
/yngz4je3ahtvv0QWCw2bcMNzEAWzYxqqVwpAPX645c/fq8bA2teLAw90q0f
apFQRwOc65vJVhg/HEYdM+gJompESizwHUe1W9fzJbPnIX7nJj1zQ39iPdcN
iftHFkjE6TJANowIH6dMn2SEPRn98WekUyOCF6hSPRHmr+uOv2Kd6o7UafCa
c3bO193kQrhwT6FQa+b5I0LkdftQAjYI4aGCXlMIEwnzYV8UxA3yIQI5DqdH
t4DExHArCCf7bSHAug0jlVbQlYruF1kWTw3MTVXWBYGctVwfSfJSobzUqhsL
Ndn6x4a4qfk2SVmgxFDUHVFNXrdFlUir6aEOM3vd2j4xApU9mThGgeWM6BBL
DsqrEYMpp0ksDSmvSQymnCZ+tlNeCR+hnPxkXlVejyRSaX0iCdxO2kRwyukS
ZIrl1QiTzVIaJHPS8ookkcrpk8p6yyuUgiqnUTKpLq9QEqmcPqm8vbxCKahy
GsWvC8qrE8cpp8vDK+ny8Aq6+Ncw5bXwEcrJf9hZ/sNO8v2rsMTseNZyGN4K
LXWT53bc648zbvJsOFFaRZBvntISoVv+pEz4MzwFJ3ZPG3WOKzFxaDg2uSDX
sGa4vypTEKB3JSoqpsWJTQyNFoUjv+uB+LNaCcAr8jNU7m/4FJx5c87XS0wb
d8hvwEywTf+6AOe1VvO9fsbHl4aSn/xfY8j/5OFu91M+7dOrxlWv5QN59aBj
n6wf88mcMN/653yyZfq3/7f6QZ9MGCv+kz7N2E/6sFKURR4YYqUo2f8bS/su
etP/N/69K8zFKRxNPVgpShYoWKBggeJVHoFgpShZwNjbgLGeZKwUZSkmF3kM
kZWi3HvKFvC4ajZvquu9vbqWNIc7F69hpSipPFaKkoWYPQgxPykryH9xh5Wi
3JmdrBQl4+db8pOVoixFTVaK8telZAFf3ZDNp8mZkePvns1vwWhWinLJStn9
wrzecasl+O9Zyu5jlsd6M+JuLI/F+Mv4u0/8/Wj1sVgpSsbVPeXqm9ey+5h7
7dvRddNey+jL6LtH9P1oWy0rRcn4u8/83Y45xR8eK1V+jpWi3DoUbKwFwYIB
CwZRyrNSlO8ZC1gpSkb5n035n7r/F6xqx0pRMtIy0u4ZaVkpygwEVoryVap0
7VSlgJWiZKUoWSlKVooy9EhWipKVomSlKIOrgyhMJMyHfVEQVooyqiorRWmz
UpQ5mrBSlL58VooyWxdWijKpTyrrLa9QCqqcRqwU5SaNWCnKDLvsXAqSlaLc
eJNn91KU57X22dpSeJo9+6HYy9mK3M+0WP27o0JPKbD6d+yfHKV9F73pPzn+
3mWt4hSOxjtW/44FChYoWKB4lf+7svp3LGDsbcBYTzJW/64Uk4s8+8Tq3+09
ZQt4XDWbN9X13l5dS5rDnStmsPp3VB6rf8dCzB6EmJ+UFeS/LcDq3+3MTlb/
jvHzLfnJ6t+Voiarf/frUrKAr27I5tPkzMjxd8/mt2A0q3+3ZPWzfmFe77jV
Evz3rJ/1MWvyvBlxN9bkYfxl/N0n/n60ojys/h3j6p5y9c0LaH3Mvfbt6Lpp
r2X0ZfTdI/p+tK2W1b9j/N1n/m7HnOIPj5WqecXq320dCja+gM6CAQsGUcqz
+nfvGQtY/TtG+Z9N+Z+6/xcspcXq3zHSMtLuGWlZ/bsMBFb/7lVKA+30ajSr
f8fq37H6d6z+XeiRrP4dq3/H6t8FVwdRmEiYD/uiIKz+XVRVVv/OZvXvcjRh
9e98+az+XbYurP5dUp9U1lteoRRUOY1Y/btNGrH6dxl22bn+HKt/t/Emz+71
71o1nltT/04WbXEm2jP8jCXhE19FkmOakPbQBrcmHm1eOfaMjBW4PDQyeeqs
VByDkgyVHqvG/M/Zowzf8zA08Xls/LAEjhSe+GFhe2Ypf2EB5n/DL8EhR+Et
w5zZkEKTQ0syDVUFYborV3oRcuV403VRw0Jl8vVm1r0fc61er81xrVyTfUp8
vrpZMiLXLqnOxCcP95E4Epw36NDhz1pVNIeYhXV5ZhOLQof3qSLacEWGUzsY
uh505grAtrQEAzm6Tebpjjazyd2QmenZm7T4Wvj2FSrH5AbxSa5JNAgg4gLs
2B+Pb8efkeHY5O6KhjXDfDk8uBIVFcvI0JGJvztwXUE6yTIi/qxWIWegaaIu
wzLQW5HQohuQcuCtZFu2aDuWcF5Fij71LBUZ370djZCn1qOjS8KkS33bsXEV
ydiSQIjuqOoJSMWmCSYQeJ6j3zVrUe6MMtTd4Bu5nwzIJdafqMc02vWW7wr0
8BQOPdPw7sqSUpdwcJYBZRnSNzr3rNkhdKKjyXHr9LzlkZdy7VO73d7yDNEE
QHExatRPU2phW2g3ziAe4Ce4dqdsh+UxyGLNsRkc0vVKeEwCbe48PmJzpugC
9J7Xz/lms+o3whLT1gZfb7by5z8qKiw/gTmrJtoIChc0QurhDgO8Rr1R45v8
H4lFurvu3A1mPcUi7ViyDw/+H1BLAQIUCxQAAAAIADljQTctnWvZKRUAAAMT
AQARAAAAAAAAAAEAIAAAAAAAAABwc3Fsb2RiY18zODg4LmxvZ1BLBQYAAAAA
AQABAD8AAABYFQAAAAA=

------_=_NextPart_001_01C80485.9C128E14
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

------_=_NextPart_001_01C80485.9C128E14--

Re: Out of memory error

am 08.10.2007 15:00:07 von Mike.Relyea

> I'm receiving an out of memory error when trying to execute a long,=20
> complex query involving many temp tables. I'm using psqlODBC ver=20
> 8.02.0500 and PG 8.2.4 on WinXP. I'm trying to execute=20
> this query via=20
> a pass-through query in MS Access 2003. If I execute this query in=20
> PGAdmin III it runs without any errors and returns no records.
>=20
> My connection string in Access is:
> ODBC; DRIVER=3D{PostgreSQL Unicode}; SERVER=3DmyServer; DATABASE=3Diqdb;=
=20
> PORT=3D5432; UID=3DmyUserName; PWD=3Dxxxxxxx; B9=3D0; B7=3D1; B3=3D1; C8=
=3D1
>=20
> I've attached the log file which contains the SQL I'm trying to=20
> execute and the error details. I've tried setting=20
> UseDeclareFetch =3D 1=20
> but it didn't resolve the error. Any suggestions?
>=20

Anybody have any suggestions on this?

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq