pgsql ODBC 8.1.200 MSSQL Migration Errors

I am converting a MS SQL 2000 (SP3) database over to PostgreSQL 8.1
using the latest ODBC driver (08.01.0200). I am using a DTS package in
SQL server to copy the data over, but I have a table with a "Text"
column, and the largest piece of data is 220,843 bytes.

The first issue I encountered, each row with my Text column over close
to 9,200 bytes, would print the following:
Data for source column 6 ('MyTextField') is too large for the
specified buffer size.

Searching through the list, I saw to uncheck the "Text as LongVarChar"
option, I tried this, but received the same error for every row over
1,278 bytes, strange.

I reset "Text as LongVarChar" to true, then bumped up the size of Max
LongVarChar from 8,190 to 32,000. This actually worked for every row
over 32,000 bytes, progress!

Next, when I set size of "Max LongVarChar" to 225,000 bytes, I receive
the same error for rows over around 30,000 bytes, strange again.

If I bump it up further to 230,000 bytes, every row fails with the
error:
Query-based insertion or updating of BLOB values is not supported.
It also looks like it was unable to allocate proper memory and is
pulling garbage data from somewhere for every row.

Does anyone have any ideas?

In addition to this, I have a table with a column of type "Image" going
into column of type "bytea", and appear to have a similar problem,
though I haven't pinpointed the exact size it starts complaining at.
In addition to those errors, I receive:
Insert error, column 3 ('imagefile', DBTYPE_BYTES), status 2: Error
converting value.

Thanks in advance!

-Daniel

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: pgsql ODBC 8.1.200 MSSQL Migration Errors

> I am converting a MS SQL 2000 (SP3) database over to PostgreSQL 8.1
> using the latest ODBC driver (08.01.0200). I am using a DTS package in
> SQL server to copy the data over, but I have a table with a "Text"
> column, and the largest piece of data is 220,843 bytes.
>
> Searching through the list, I saw to uncheck the "Text as LongVarChar"
> option, I tried this, but received the same error for every row over
> 1,278 bytes, strange.

If you uncheck it the Text is VarChar (smaller than LongVarChar).

> I reset "Text as LongVarChar" to true, then bumped up the size of Max
> LongVarChar from 8,190 to 32,000. This actually worked for every row
> over 32,000 bytes, progress!
>
> Next, when I set size of "Max LongVarChar" to 225,000 bytes, I receive
> the same error for rows over around 30,000 bytes, strange again.
>
> If I bump it up further to 230,000 bytes, every row fails with the
> error:
> Query-based insertion or updating of BLOB values is not supported.
> It also looks like it was unable to allocate proper memory and is
> pulling garbage data from somewhere for every row.
>
> Does anyone have any ideas?

Could you post mylog outputs for this three situations? It would
be better if you try it with max 2 rows (it results in smaller mylog).

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: pgsql ODBC 8.1.200 MSSQL Migration Errors

Is there a max file size, or max # of attachments, I sent 4 .log files
yesterday, it totaled around 200K, and I havent seen the message come
through. Is there a delay on the list?

-----Original Message-----
From: Ludek Finstrle [mailto:luf@pzkagis.cz]=20
Sent: Wednesday, March 01, 2006 1:59 AM
To: Daniel Holm
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] pgsql ODBC 8.1.200 MSSQL Migration Errors

> I am converting a MS SQL 2000 (SP3) database over to PostgreSQL 8.1
> using the latest ODBC driver (08.01.0200). I am using a DTS package in
> SQL server to copy the data over, but I have a table with a "Text"
> column, and the largest piece of data is 220,843 bytes.
>=20
> Searching through the list, I saw to uncheck the "Text as LongVarChar"
> option, I tried this, but received the same error for every row over
> 1,278 bytes, strange.

If you uncheck it the Text is VarChar (smaller than LongVarChar).

> I reset "Text as LongVarChar" to true, then bumped up the size of Max
> LongVarChar from 8,190 to 32,000. This actually worked for every row
> over 32,000 bytes, progress!
>=20
> Next, when I set size of "Max LongVarChar" to 225,000 bytes, I receive
> the same error for rows over around 30,000 bytes, strange again.
>=20
> If I bump it up further to 230,000 bytes, every row fails with the
> error:
> Query-based insertion or updating of BLOB values is not supported.
> It also looks like it was unable to allocate proper memory and is
> pulling garbage data from somewhere for every row.
>=20
> Does anyone have any ideas?

Could you post mylog outputs for this three situations? It would
be better if you try it with max 2 rows (it results in smaller mylog).

Regards,

Luf

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

Re: pgsql ODBC 8.1.200 MSSQL Migration Errors

"Daniel Holm" writes:
> Is there a max file size, or max # of attachments, I sent 4 .log files
> yesterday, it totaled around 200K, and I havent seen the message come
> through. Is there a delay on the list?

AFAIK there's only a delay if you're not subscribed. There's a max
message size (on the order of 20K IIRC), but I think majordomo will
just instantly bounce any oversized message. In either case you
should have gotten a response message saying what happened. You might
want to check your subscription settings to see if the responses are
turned off for some reason.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: pgsql ODBC 8.1.200 MSSQL Migration Errors

This is a multi-part message in MIME format.

------_=_NextPart_001_01C63E30.93303F02
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Trying this again, with the attachments zipped up.

Row1: 80804 bytes
Row2: 63456 bytes

Attached are the results for the following 4 runs:

mylog_4172.log
Unknown Sizes: Maximum
Text as LongVarChar: Yes
Max LongVarChar: 225000
MSSQL Error: Data for source column 1 ('textfield') is too large for the
specified buffer size.

mylog_3988.log
Unknown Sizes: Maximum
Text as LongVarChar: Yes
Max LongVarChar: 230000
MSSQL Error: Query-based insertion or updating of BLOB values is not
supported.

mylog_3988_2.log
Unknown Sizes: Maximum
Text as LongVarChar: Yes
Max LongVarChar: 64000
MSSQL Error: Query-based insertion or updating of BLOB values is not
supported.

mylog_5968.log
Unknown Sizes: Maximum
Text as LongVarChar: Yes
Max LongVarChar: 32000
MSSQL Error: Data for source column 1 ('textfield') is too large for the
specified buffer size.

I tried with 64,000, but it came back with the BLOB error... so bizarre.

Thanks for your help!

-Daniel
-----Original Message-----
From: Ludek Finstrle [mailto:luf@pzkagis.cz]=20
Sent: Wednesday, March 01, 2006 1:59 AM

> I am converting a MS SQL 2000 (SP3) database over to PostgreSQL 8.1
> using the latest ODBC driver (08.01.0200). I am using a DTS package in
> SQL server to copy the data over, but I have a table with a "Text"
> column, and the largest piece of data is 220,843 bytes.
>=20
> Searching through the list, I saw to uncheck the "Text as LongVarChar"
> option, I tried this, but received the same error for every row over
> 1,278 bytes, strange.

If you uncheck it the Text is VarChar (smaller than LongVarChar).

> I reset "Text as LongVarChar" to true, then bumped up the size of Max
> LongVarChar from 8,190 to 32,000. This actually worked for every row
> over 32,000 bytes, progress!
>=20
> Next, when I set size of "Max LongVarChar" to 225,000 bytes, I receive
> the same error for rows over around 30,000 bytes, strange again.
>=20
> If I bump it up further to 230,000 bytes, every row fails with the
> error:
> Query-based insertion or updating of BLOB values is not supported.
> It also looks like it was unable to allocate proper memory and is
> pulling garbage data from somewhere for every row.
>=20
> Does anyone have any ideas?

Could you post mylog outputs for this three situations? It would
be better if you try it with max 2 rows (it results in smaller mylog).

Regards,

Luf

------_=_NextPart_001_01C63E30.93303F02
Content-Type: application/x-zip-compressed;
name="mylog.zip"
Content-Transfer-Encoding: base64
Content-Description: mylog.zip
Content-Disposition: attachment;
filename="mylog.zip"

UEsDBBQAAAAIADRsYjROuatq0hMAAO6iAAAQAAAAbXlsb2dfMzk4OF8yLmxv
Z+0da2/bOPJ7fwVvv7hdOIEkP5OcCji22zXOjVPb2btFEQiyTCdCbckryU1z
v/5mSEnW25It59FLFuha5JDz4HBmOKSob2JNEm7vluZMXdqn9KdjqYr9aDvq
bEmVtUUX+k9qE5lU5nPlovLuW12q12+/fZt8HXaWS1P7QzXmS3p7y8t/hz+i
G+T6c+d6oDCAvvGDQOE7D4DQn7oTATgn63sKcDKpNc+EervehiZBVBPqAFjH
cazbW6I6jiwJQlXaQUwAR9c0DKo554QaDrV04+709PRdgOQk0AhFVaJBDS8Q
xWa97bbvXykqiEbjzXTTOCc2XS5ytCT8D1rTOTBFdCILHPbkYyJy+5t+G6vy
hAAy+EydgbEw39eEDyERuOUh7hdYMn1cU7nVepcIvJYrQu1UECpVsqSG3KiS
H+pyQxmNsy/qT1mUArh7lv6DWq7wQthDNTtGIAK78J5X6yVF2XoCmjjWwJAr
vcmVbNAHh67WFzeDnsx+XP+7J/9kf766mhvLGyDFdhA7KnTe1qBvlj7bONRt
VHElgY9uew9UM9ePHQ/cPieIwoep2tQCbuRKpTqfqTbFHxubF6xV236YyxWG
GR5Ny8Fi216uzDmDNI3lo0XVOf5GXhSbOg5wYrP+dFsF5X3ACbtSnY1F5RPx
QxL9wGiQ/hKI59VPxgAMUJABju+lc1DQvBYEfzL17oJ8YTKuTCMo5U5LFgXh
otOW2+KZdNE5k4WLS0GWGvWLS1Fu1gWovJRk8eKyhjV1/NXAf5r42MJfbfx1
Br+6AvzqiviPJCOPxVT4ZRCYpaLPRmG36+lIkg3e1r7/wOZNcPSrhE8dLBOl
1qkA/4lQilMEyxr1moRAfKZgCWoqtaBsroLqwmTzB6pKcM4Z6ipYxKaeafmT
z5/O3KeCPjsmce6pR0dqvY8OsGCxTy1R7UAHbntWoP+XEt0mYiPaq2nEerU3
mkYpuOvTPWBBxEvT/L5ZK+s7BYiwWawQH4pALDJxVomjNekq4CNhqm80x7S2
ECQdRAPD5UCcYUOXbvTQgMAvJQjiiO/nMy0QtlRTGgNjGAGBkYLhBFJ4ACSH
m8mRRhxZ/yfVerqVopRQ/qgtQZSRnqMEXPc6046ysCiYSNVSVzChSP9q2h9X
fUqERqshxZkN4r8PkVndYpUr0AuAEHfQ3n+opDKhgQ/AgdjWwASPjq1bnD74
PgBwr1qEWpZp2UeXC8d9tVldu8Bx8pAw5UF37nmHFOptxaK2ufxB50AuGDfk
3ieMeHjBjxk2U5GNLYs8ohSbrmqkyheiYwQIYGS+LwMc/ybUmCMVk/6w350G
iIFZGhljbWPZpqWgOZIrEMUq3ZuxINVqkthse73a0J3y94Zaj2gaccYHVJuV
pzMwHFxef1UoH07eSeJshSXT13FwwrrlbK2UWJPY8x11iAFBA4Eh2SwdgnIj
XOggNymrKfsfAEU5yWoDWBziwBrCDrCSAqkB1xDAmBq1bTpXLAiUNHNjoDkR
t3Zkpa7XIJlEGQWroTlyJOJqYLlZGXZKN7wWKoWESojeyEKnyzmsWHHB4zol
l/UqcoZSa7BfoLDwcCI2aqC14O0f1+DrWMl2CKfDtCFMrAnSsqCOdr8l16fB
CyKuTdu5syioKGmfiqc11GW92W6erLWTFfTwUJNQFqu1vgQjP3skn7tdcqdp
EEJS8h4ePpDaaf1UIu8Z9Im9ppquLr3h3er4OZmbBvpJPoe4WgT06NxXI1BL
RrXibEA6UMEnE07QCjcwJx95kSykNQHH75DuQMGoWmFjAYXGZuX+Dozql85w
OOqCIcGWCvPaUCmgnea/24KHhRmBEBfomDl3/qA4yDGXtzLTGZgdVruAjaw3
YNA9KAXDfA2dKa5GkVhXB2UxOOTJKFIdh0VhyWDA2AlkYZmrsAMJtfqEEjyP
+mJuSk8+8pnvlp+1627TlWps1KXi2gU2cyAOU+ZUW6oYq6H2bWcJ85AQQSw4
qlDjsATB4mDEo+ih/EJEfM0WiO+OwRWS3Z3ftVvp0gNtuBNZYC/m2rE9QbCB
woKTj57EeVWtJqC5nm0WEJd+uw3w6mc9eoDMZSE5ZGF65Uf1x5qRleAYRIjT
gXMkvUoWXczd8IFkc0Vx+LPUqD4djejvFZVpuQEmCzM2UVoWmuMTeny6MDX1
J2Lh+SkvOdbrf+rcDKfnhFvxNmjC2rGeQkIsHsG4Qun+0YG4a04XKkyiICVb
ilFKEpRYd7zoElR4bD48BZ2fTYdZyQAe1wcRnlE4Pz4Nfcx2aLhISaACbMWM
wjqmAqjD4fcniG9jC6VoML8YrVn+0DMzX8fMmJ1jsrrXn0zHN93paOxWTtHH
DHV7dzWzVjEAv3MMvcmKrkzwobqBkwFDHljqx8gIQpobJ1qdjAcsdI9ul3hb
g8v9AfPArj/wn3FN58evbj+d696uVUKj5bn9wW7gZq3pjVCxFUhn3PvEHD9r
QlggvhDIDJbNK9X6LkNBa94UfGBlY6CZRydiMxGCe5Fhre87GdH32ti2PZ95
LINYqKOoEfdcOAAAo4Y22Ver40nyM5Pkbn6Zz+TMUs9xRfSk/5/B1K2BEJSF
fl4i8y0f8UryEWAN4GniPAI5jkkqg8mo8paVKCMrIUnbrESWlFNzEzsawZ/u
VGxyNZoS1VtuB2WWoJz5UhBZiF9UIkLMarpNRCTxk9UyM8ngr9On3lqQPKg2
cbuY83StbS82y+UjgZB2u2Ykc31ODNNxl2hQ+eixFRueyOoZgiFYO81T52We
RV/cRLvIXZMAEhV565DEjmDWMmOmXTFPrJO9Ip4nsax39G+TKdzo06c3o1pO
qrcVNKqJAs6wp2nwxzSliThfpxUNsfJmQLMNKArrzXbubTv5iYXF0lQdZa7f
6Y6Nmie9WdFSQtOQFd0h6gx7urvlMS3rDuyv08amMPVmbbOtbVxsIeTlp/ae
xtT+XybmmlKBxJywTcwJR2c2X+5McHNnubJm7kmepZnuk94yZi/vBI8JtpEZ
n/Ud36R6uKcWxf19fgRkab4t+EoJVeqBLFpRyWef+inW0fOeBypA66s9KZSD
x6zerHLOECWd70mQXsIZIuEYZ4hAKP75oWbg/FC9rLNDbwd29LcDO9FDLOWH
y2874b9KwB3eCZdqM091rF9zJ3yfaF67V9kBFAskkhQhFfD84Ay1pY7+ihqa
icL6BQ4FJzGV1bwk3/7CzgfHpeC5evEs4Oqbpfn6jHPCSbR4p+wwfO1MuoNB
THt/gZDhl/BaeTOmkSFmezlL1dGNs1e+M5XB2N7W4gVkTl9ABjL4th9nJ+zJ
/tvlb1GPNuwNvuC7ouheLzuTPn9hdNIf/9kfy/6LdBfXo/FUxjf+LiaT4ZdR
ry/zl/0S3zEdw5wfGctHWbj4pH6nI30+MOb0JzxO7s0HeOwySwbPY/PhT37U
Ewh16yePNnQ4xXdfbXydEUn23ri9YFE1e2tyYmrfqcPfnLwxvhvmgzEBe4FN
vqg//1Qt9OtYwt6nhKKhadwFi/n7lT0629zh+5MwlkMTacBIeQUAFpT+y/7b
hP/d2LTHQ3COX7iYwjTo2IEuEYpTYYfLhYtLE8KVjt3lUNcqBBrIl2podNmx
vfAdithRWGCf8X7tvvbLXua8GH7qssPWNgviL27W7I3DJe0yM4xM99w3ka/9
F5GBSmtDB/YX3djY+Gbo5QD/eXSo6pN4qRuqhQMFLE7YW5ITfY64ISbDHobm
A7W6qk0Hc5h8Ohhv4KjCrwZo1auiIHlLF74YibzK7yuh72q/uVcW9HT1bky1
29tQ823F1ozBvJdFDhTIALoo+phI4xlP34qSfwofPQOHnRCYFmC6FJZ0i1bw
/CqvW9l3bjX8Yt4uaCdTgb3aKA4o+uwVbReOYGrucVam8g29Idui7/VciX3a
GOydU/s2VLzH3Q9SLYrcv/vhn1c3w+FH9/IHybv8QfIuf5DeHYy7/ny4W2f5
cNc93DUPd/1g3O2cMvdxC+XhbrUL4hZL5FssirtRIuNSUeQlSr1dFPlZicjr
OafZlvNWiciL6nqJ+iYmc14TnmaqiQ2hMPp6s12i8MVm4s0+T0lBvVmYgjI1
oJFocp4MfTPR2j4ZejHd4F65eMWY4jfEw72rmDjqDLGLV4jhFQ7Gun8sc7is
949lSrCx6dLOi9u9Ys2NpN1r1sLaE65OreSbC4HUg7vdgFkB8oNtPgeybdAO
FzwcBHMgmLP60vmPMh79e1KNwycTKmQRmlaZQaiwg1BO5teb/vgvZTr40h/d
TJNo3XtA08fzGvoc9S67ndPecOhN4Vp8Dh8+hd9oKImGEi7oyxk3S3HcwWnz
OTa/hdgiKDTDU6ujU2ebVjrAgOY0YvV0I7Y37sQ4LUO+7B3t8rx0UddR5tog
fWFyREe9D9bDZ/JZ0UVYmcvuRlEVKzE0ycn3UXCnot5eLYe4z44RDu6NWyoB
efqAp4feJRiT9Ktct1cqePiPMbUPJEA6fJqL6RkuoX0qiKeCJAhHu07J06lj
KPRL5UyKpqf34K2dMy95FCNVFHeJoYcoPKNXEoWiqcFSkacv1/86pokUii6X
y0wEF40D6uXhPksPc4/pkp4zM/KcGaF6urjZuYX5xqJHjH4OQl9CAHRWVPQl
brDV0jf3bO2erlQXd/MIct8ft1jCFC+6wyadlWhYn3GN00rXtmPatrOcLB9l
R7OejpydB3Fxxz/bUIJx2Rd1CXsL9fQVRmBRd4ypvS/mEiZ2LT1myREruXgj
2T9pR/pvW3+ATUifl8F75I/lBA9CX0YW4HlCLjHdBx0T7TMZYTGv49laYanE
LW4p3ececxlz8L7EC9imkg7fGsn4dJGfEvEIOEa+6zD8ZaS7Mmxc+qwrwbTu
hbeEkCt9Oakckd290JbAbbp+HT1XcVY0LVYm7pzHM4+Be3va9lmQH77Zu3+A
W/RQbJmMP+PqsZau6ekuvIRUwT5oD+c2+Vhixii3pHaJaYLkI3lPo2SNosn2
Mk8/F82Dljm5DkaNuDuZX9j8hS+68RbQiMldPXMx+ID4ioYYm1cefCZ0zs5j
Q5jZuVis89i0yOxcKtZ5LE7M7LwW7HyS3Xm7GpH5JKvzAHS+zgv1XaTrVrUh
tpqRbcfM/iMt8iEpQH8rRn+P2hq7gAD6vndf168L/A0s/lI0Bkp1NBhyizYW
WhSZ30G+5j4Bvf6kOx5cT0dj0h+PR+NzstgYmhzvF7+lYWvsyBC1LGOzgjUJ
+7my7+TKTJ0T/xoj9+MRlSCP2YobW9umyi4RMv2EXAjAO/HavRlPRmNl+td1
P/Z2XAaRscVBKpGJkEWJHF0BneP+VfcvErUv0YOFscgmfLAwrTrjYOFujZek
auxQcqpAAsB5uhYLTKYAMPa8vTIm5DNf17Vpv/Mrbn7DPDffxvrtlD2wdP9v
b1emlXFlWq0RuTItp9Szr0vL38nzXpWWk85Xe3fKDv6yevo1r0hzQKwL7sid
I39o8e2yNP0VXJYWvA/ACz1d5/q+VnUtywcyhhhSIIO5fCJK8YyV33jLLAad
wArvimdeqgThAhcZ7OrLfRM/6NjH5kMXZ1bIrXuFSc4i4H09MLSK0z/6BF93
Oie/rzWLfe0tiAb8D7/po2su7RCuUE3K0nttUc9GnG/tVnhJFunHv3GO6cZZ
u14NNGQawe7c2uru66ES1w6WPqPQRYjGQHmAQjE/iYGhDfVlUTtCIt74FyT0
Hwvd0O17Ptv+sfZv7PDIBgeEt4Xwa1LwspJz5glkNJZ43Rq02vDLRgJ6Mw/S
AFA461CPt19dd01vZUcDRMUsczqcawFcM8XMdjrw7+vF5O/llPfqG/QEQJwL
M3ju0UU2XwCozyYQZtKdcIurzXKJzjaoFagWAIaRPPsWfzizFawJKS+KXoR1
PwvcGqK0j6bwzvdQZY1TFRopJTpUIQbOSXc0vPlypVx1vvQTNeAwQdSYHISX
J4W9pk8iywwLC9TvnODNmwdqkPBSJRfRnxtcPPU7l0NUnwIZwFeRSHkhRO5I
QtSqDbEtNcIkZGYiIi3yISmQ6agVSnsWSaKkAaeLOvFV8nF/Oh70/+wruPKv
pr9Pnk12/rRSGnBJZIe81jNux0htqe2JsPB2TLBx7u2YYKPMCc0Ac2/HxKFz
dp5nOyYOnbPzPNsxceicnefZjolDZ04UDi5Ua3nmdzZwzomSfQOD37UrkT12
TKX0oxC/HXFvvp6+U+tijR8iK+H8Q2yq7NgfbvqvJR1+gK229754CbiLvhpd
KuNFT7wkID8s9mxxPZbOXl70eSBnTcZZs/GrMSbVXixjIfrPCV4gq0xxveCv
OctZakrSqxLBcdfd4otdeCNb3n22IY4KfaPCM3RpHzgQUj9w0Go2Pa9mHecD
B+mfIRAyPkNQjly2rJXw9dHXclt6we3bb56ok9ZI2dJmMWr8SykpHxlxoUv8
yIjUbvihyc5PYwDwWYGPjEjtlhiYVpGPjLRmavgjI21aO/JX/fZmtuzvgByg
MJHpuUNhvGMWv+RXafDLMvkV5qmN9uv5Kg3br9Jt9xL/8HaVX5y0UI7DqDOw
sfhtBby3fElVY7N2YcHeQ1mXl235CuqeunD49ejQi+VZan8Urj93R1dXAR68
LyV4O6apALxfdooBD/IlbOVvKUvljG2Dx7iKwyV8AWHnbO+mi5hFUSC7BOCk
6cs6QDK3UkiWde7hKCQ2fwSTitk83h7zuTeXc2rZkf56UUQJjOcXcVx6feMH
ivmHG4TW2/U2AZitVPpXibJjkEFaQ3BA049A2EoIMb+/+x9QSwMEFAAAAAgA
NGxiNCDI+AOTEgAAjpIAAA4AAABteWxvZ180MTcyLmxvZ+0da3PiOPL7/Ard
fmFmi6Rs807OU0WAzKaOhAyQvduaSrkcIxLXGJu1zWRyv/66Jdv4DQaTx1yy
VbMgtdQP9UttWXyrCe367b1h3amGc0x/uraqOE+Oq94ZVFnadK7/pA6RSWU2
U04rH74x8G/fJl+HXcOwtD9Uc2bQ21ve/jv8Ed0k11+61xcKAxiYPwg0fvAB
CP2puzGAE7J8oAAnk0az1RGERhOGhFFNqAtgXde1b2+J6rqyJAhVaQMxIRw9
yzSp5p4QarrU1s374+PjDyGS00BjFFWJBj3QUGvUm512o+mNH1wpKohG48N0
yzwhDjXmW4wk/A9G0xkwRXQiCxz26HMqcuebfpvo8oUAMvhC3Qtzbn2sCZ8i
IvDaI9zPsWX6tKRyq/UhFXgpV4TasSBUqsSgptyokh+qsaKMxrtL9acsSiHc
fVv/QW1PeBHskZ4NKxCDnfvfF0uDomx9AU1c+8KUK/3JlWzSR5culqc3F32Z
fbj+d1/+yf4CdbVWtr9AiuMidlTobUeDvtn63cql3qCKJwn86o33QTVr+dT1
wZ0TgigCmKpDbeBGrlSqszvVofhh5fCGpeo4jzO5wjDDV8t2sdlxjIU1Y5CW
aTzZVJ3hZ+RFcajrAicOm093VFDeRzTYhequbCofiZ/S6AdGw/SXQDzvfjYG
YIHCDHB8r52Dgu61IPizqXcP5AvGuLDMsJS7LVkUhNNuW26LHem025GF0zNB
lhr10zNRlqSGAL1nkiyentWwq46fGvhPE7+28FMbP3XgU0+ATz0R/5FkZLKY
Dr8SCvOU9OVI7PV8NUlzw+vej5+Y6YQVoEq49WCbKLWOBfhPhFa0Emxr1GsS
AnFjwRZUVmpD20wF7QV7C5aqStDsTHURbmLWZ9mB/QUWzcMqqLRrEfeB+nRk
9gfoAAs2B9QS1QlN4I1nDfp/KdEdIjbis1pmYlZnpWmUQsQ+3gEWRGxY1vfV
UlneK0CEw9KF5FKE0pGJu0hdrUlPgTAJ1r7SXMteQ5BsEA18lwuphgNTguRF
UKpWo9ZsZyRCHPPD7E4LpS7VrNHAGqZB4KlgQYEYngXJ0XFyfBRHN/hJtb5u
Z+gltD9pBkgzNnWChOt+d9pV5jYFT6na6gKsigyupoNxlQ/g8G1BSDIcpuAh
Sml1jViuwDwAQ7yl+/ipksmHBsEAl2PdA3YeX2GvOVsFAgAQgGoTatuW7TyD
aDj2q9Xi2oNOEoikKY+6+8BnpNDvKDZ1LOMHnQHB4OWQ/4A04iOGkGY6TFFW
jizy5FL0FSRTwpAoI0AIIwuDOeD4N6HmDKmYDIaD3jREDFhrfJm1le1YtoJ+
Sa5ARqv0bsZCqz5odIW2P60D8yl/r6j9hD4STT+k4aw9m4Phxdn1V4XyFeWT
pJotbJ++jsOW67WzfVNqT+rM99QlJiQQBNZkZbgEBUe41EFwUt5Q9j8AinOS
NwawuMSF/YQTYiUDUgOuIZmxNOo4dKbYkDRp1spkbmXtThbqcgmSSZVRuBuG
I0ci7gyM1cJ0MqbhvdAppHRCJkfmOjVmsHvFzY8XnTzWq8gZSq3BPoHG4pd2
rSNVcTf6tISgBy1HPlpYwukwawlTe8K0zKmrPazJDWjw04lry3HvbQoqStrH
4nENlVlvtptHS+1oATM81iSUxWKpG+Dt757Il16P3GsapJOUfIQvn0jtuH4s
kY8M+shZUk1XDX951zp+QmaWiQGTGxFXi5AenQRqBGrJqFbcFUgHOrgxoYVW
uIs5+sybZCFrCGQALuldKJhhK2wtoNFcLbzPoVW97A6Hox54EhypsPANnQLs
Db3Pa0fGvECEC4zQnLtgUVzkmMtbudMZmBNVu7CXbAj1KvHBFMz5NQyruDVF
aj0llMXwmqfjyAweNoX9gwmLJ5C5bS2iQSQy6hxFeJIIytybHn3mto/FAkFq
NFv+ci1Uc6UaiucZmO1ASqbMqGaomLah/q3thMVJSCbmHFdkcFSG4HMw+VH0
SLUhLsCWBAK8Z4CFpHcfzO11egTBGB5I5jiLtXSdQBRsrbDl6LMvdOhrNDoN
qS2AlO5Wc0hSv92GuA2qIH3A5jGRkb0w5QqS/EOZZSW8DDHqdOAdaa+SeQ+L
OXwtmcEoLv8uNarPRyNGfUVlmm6C38ISTpyWueYGhB6eLqxV/YlYeMHKX7n+
4Lx7M5yeEO7K26AKS9d+DgmxrASTC6X3RxfSrxmdq2BHYUrWFDM9hhb7njed
gQ6PrcfnoPOL5TJXGcLjBSLCSwwnh6dhgOUPDbcsKVSAt7ijsKupAOpoGn4O
aW5i25TI6uejJaso+p7m65g5tBMsX/cHk+n4pjcdjb3OKUaaoe5s7mYOKwEQ
TI4pOFnQhQWRVDfRGjDxga1/gowwpLVy493peMBL9+l6xxdyujwosEDsBQXB
/45bPDlWm+5e9zduF5qS7zMvtoFu1/1VKrgZ6Y775ywFYGNIq04bakcgd7CT
Xqj2dyC9MWvV2gGwsjLR2WMscZgYIcrIsP0PYo0YhG8cqzVU3y2AZKirqLE4
XTwVANeGnjnQrUNK8wuT5maWWfSUJXE2a9Z9TDF1GfznYur1QD7K8kC/wvle
pXhTVQpwDfBt4j4BRa5FKheTUeW9VlFOrUKS1rWKPDlnViw2DII/3a045Go0
Jaq/Bw9LLU1FtytM5GF+VeUJMW/oujyRxk/eyNzSQ7B7n/o7RPKoOsSbYsar
uY4zXxnGE4Ecd72TJDN9RkzL9fZt0Pnks5VYntieGrIj2E/NMk1zm51g0ld7
yIWqL1GRj45I7BDOLTeJ2pQECXlwW6dAz+Rf7+nfFtO50fn5u2stqwzcCrvW
VBHneNUs+IM61FSkb9OXRlh5d6P5bhSF9e5B9/Gg/HDD3LBUV5np97rroPJJ
7760pDQ14ks3CDvHq24eeVD/ugH92/S0GUy9+9x8n5sUWwT5Aep+z+Nw/1+r
dlh5C4A3lrCEddVOeAZ+t6urCV5dbauKmnf2x7Cyo9N7NY3BvMIzPxY4SuaJ
lvf8cdbjA7UpHgfgJ0YM630bWFLqUg9V2IrKPv+cULGJXvgEUQFi3+zZoi14
zJvNLufUUdqJoBTppZw6Eg5x6giEEpw4aoZOHNXLOm30fsRHfz/iEz7ic7AE
+v3B+a+UgscenM+oj8n+ZR+c75Lgaw8qO7dig1DSkqUCOQCERc3QMXJRU7NQ
XL/AgeI0pvKGlxTlX9nZ4qQU/KAvdkJBv1la1M85Y5xGi384DxPZ7qR3cZHQ
3l8gefglgte2tdTYErNnPYbq6mbnjT+5ymFsZ2/xCmqqr6A0GX5lkLMTjWT/
7fG3sUcr9hpg+J1TDK9n3cmAv3g6GYz/HIzl4G280+vReCrja4Onk8nwctQf
yPyNwdR3Vcdg8yPTeJKF03P1Ox3pswtzRn/C18mD9Qhfe8yTwfex9fgnPyEK
hHr9kycHJpziO7QOvhOJJPtv7p6y9Jq9ezmxtO/U5e9f3pjfTevRnIC/wCGX
6s8/VRvjOrawtzKhaWiZ95Fm/pZmn96t7vEtTFjMoYVEYMa8AAgbWv/l/G3B
/24c2ue5OCdAOJ2CHXSd0JwIxclwou3C6ZkF+UrX6XGoaxUyDWRMNTVqdB0/
j4cmdoQW+GfMX3vvD7NXQk+H5z12SNthyfzpzZK9t2jQHvPDyHXfe6X5Onij
Gai0V/TCudTNlYPvl55d4D9PLlUDEs90U7VxpYDFCXvXcqLPEDdkZTjD0Hqk
dk916MUMrE8H7w0cVfgdA61GVRSkIN9lu5LYnQCBFgax9pt390FfV+/HVLu9
jQxfd6z9GBi+LHKgUEHQQzHAshovggZulPxT+Ox7OJyEgF2A71JYCS7ewWuu
vG/h3Hvd8ImFu7CjzAT2e+M4oOmL37TeQoKveUCzzOQbZkO2xSDseRI7X5ns
zVXnNtK8wyUSUi2OPLhE4p9XN8PhZ+8WCcm/RULyb5GQPuyNu/5yuFud7XDX
fdw1H3d9b9ztLWUe4BbKw91qF8Qtlsi3WBR3o0TGpaLIS5R6uyjyTonI61ua
2ZrzVonIi+p6ifompnNeE57H1MSGUBh9vdkuUfhiM/WKoOekoN4sTEGZGtBI
dTnPhr6Z6m2fDb2Y7XCvPLxiQvEb4v7RVUxddYbYwysk8Ap7Y909l9lf1rvn
MiX42Gxpb4vbu6vNy6S9+9qi2hPtzuzkDxlCtQfvsQOWBcgP9iA6VG6Dcbjh
4SBYBMGi1WX3P8p49O9JNQmfTqiQR2hWZw6hwgZCOZlfbwbjv5TpxeVgdDNN
o3XnBc1ez2uYc9Q/63WP+8Ohb8K1pA3vb8LvNJREQ729Nw1b5s1SEnfYbL4k
7FtIbIIiFp7ZHTeddV1pDwe6pROrZzuxnXGn5mk58mXvdpcXpYuGjjL3Btkb
kwMG6l2w7m/JnaKbsDK33Y2iKlZiarIl3wfBnYl6fUEd4u4cIh3cGbdUAvLs
Bc9OvUtwJtl3wq6vYvDxH8K09yRA2t/MxewKl9A+FsRjQRKEg93F5OvUIRT6
tXImxcvTO/DW3rIueRAnVRR3iamHKLxgVBKFoqXBUpFnb9f/OqSLFIpul8ss
BBfNA+rl4e5kp7mHDEkvWRl5yYpQPVvc7ODCbGXTA2Y/e6EvIQHqFBV9iQ/Y
atkP9xztgS5UD3fzAHLfHbdYgokXfcImdUp0rC+4x2lla9shfVtnS5YP8kSz
no2cnQfxcCd//6EE57Ir6hKeLdSzdxihTd0hTHtXzCUYdi07Z9kiV/Lwxqp/
0oby37p/D5+QbZfh2+gPFQT3Ql9GFeBlUi4xOwYdEu0LOWFx28Cz9sJSiY+4
peyYe8htzN7PJV7BYypp/0cjOb+BFJREfAIOUe/aD38Z5a4cH5dtdSW41p3w
lpByZW8nlQOyuxPaErjN1q+D1yo6RctiZeLe8njmIXCLQnbUfgbk+z/s3T3B
LXootkzGX3D3WMvW9OwQXkKpYBe0+3ObfiwxZ5VbUrvEMkH6kbznUbJG0WJ7
maefi9ZByzSuvVEj7m7uT3X+2pff+HtoxOVtoLkk1pD4moaYsC1/QD74ttMn
FjJ/erHg9AnzyJ9eKjh9ImPMn74Wnn6yYfp2NSb7Se70IfAtpy82e6HJW9WG
2GrGHkPmY4gN2RJNER5aCR761NHYvQQw+4N/IUC7zd/K4m9KY/JURycit2hj
rsXRBTNsOT4goT+Y9MYX19PRmAzG49H4hMxXpiYnJ8Yf5nA0do6I2ra5WsBG
hX1cOPdy5U6dkeCeI++XKCphLjcocWLHmy2/VNDsg3MRAP8gbO9mPBmNlelf
14PES3N5ZCY2DdlkpoIWJXN0BZSOB1e9v0jc48RPHCZSnuiJw6zunBOHW2i+
JFUTx5WzRRKC3mpysYhZhaBx7vXNMpGA+uYuWfudX4bzG9bB+WOu347ZF/Y4
4Lf3C9bKuWCt1ohdsLal3PMvV9t+khe+WG1LQt/s/Sob+Mub6de8UM0Fsc55
WHcP/EOO71er6W/harXwnQF+LuoF2Y+1KrspS2h/ImNIKQVyMZOPRClZ1QoG
r7nFHBRY4VPx6kyVIFzosoNNc3lv64fj+9h67KFpRaK735gWLkIh2AdDtzj9
Y0DwlagT8vtSs9kvyYXRQATi14H0LMOJ4Ir0ZGzPlzb1ncTJ2nFFN2uxeYLr
6fzb66qhgUwj2MVca+V9O1TiVsLW7yhMEaEx1B6iUNyexNDSRuYCKmMk4vWA
YUL/MddN3Xng1vaPZXCrh082RCC8UYTfpYI3mpywUCCjt8Rb2WDUil9IEtKb
WZgGgEKrQz1e/76753srGwYgKuaas+E8D+D5Kea3s4F/X84nfxtTPmvg0VMA
0Rbu4HufzjfPCsD63QTSTZovA0R/tTIMjLhhzUDVADDM6tlP/0crYOGeiAKj
+EUitln61hClXbSFT76DOmucqshqKfHlijBwQnqj4c3llXLVvRykasGeghCY
IIRXL4Yb3AoMumdDlEKROtdrKBFAh3+VUGRxit0T6nOddcGkkHnB5KwT7KgO
dcFk9iWQQs4lkCVJRgiYK+PHYd7KbXVFN8fffGmnPTLY7cra/9ufSW1SId8Y
s297fQZjfEu3vbIUT3e8y/GiGV7QnF1pCsOod2A7eGchXgdmUNVcLT1YsGNo
6/G2avQBkweizl1+6xjMYvsWGCzE9Zfe6OoqxIN/A6G/ycgE4POynT+WwlO2
v2vKMjljW8cEV0m4lJsFN1p9L1vELNiD7FKA04yYTYBkrqWQLuutl6OQ2IIV
TGtmpryujT1YxozaTmy+fhxRCuPbizgpvYH5A8X8g+VKrY4gNJoEYNZSGVwl
ZedDhmmNwAFNP0LZFSHE+v7hf1BLAwQUAAAACAA0bGI0ZHewj34SAAASkgAA
DgAAAG15bG9nXzU5NjgubG9n7R1rc+I48vv8Ct1+YWaLpGzzTHKeKgJkljoS
MkD2bmsq5XKMSFxjbNY2k8n9+uuW/MY2GEwec8lWzdpSS/2Q+qG2JL7VBEG4
vTesO9VwjulP11YV58lx1TuDKkubzvWf1CEyqcxmylnlwzcG/u3b5OuwYxiW
9odqzgx6e8vLf4c/opvk+kvneqAwgL75g0DhBx+A0J+6mwA4JcsHCnAyqTeb
Ql1sNaFJFNWEugDWcV379paoritLglCVNhATwdG1TJNq7imhpktt3bw/Pj7+
ECE5DTRBUZVoUMMLROGk1fTa968UFUSj8Wa6ZZ4ShxrzLVoS/get6QyYIjqR
BQ579DkVufNNv12r8oUAMvhC3YE5tz7WhE8xEXjlMe7nWDJ9WlK51fqQCryU
K0LtWBAqVWJQU25UyQ/VWFFG492l+lMWpQjunq3/oLYnvBj2WM2GEUjAzv33
xdKgKFtfQBPXHphypTe5kk366NLF8uxm0JPZw/W/e/JP9hdMV2tl+wOkOC5i
xwm9bWuYb7Z+t3Kp16jiSQJfvfY+qGYtnzo+uHNKEEUAU3WoDdzIlUp1dqc6
FB9WDi9Yqo7zOJMrDDO8WraLxY5jLKwZg7RM48mm6gyfkRfFoa4LnDisP91R
YfI+osIuVHdlU/lI/JRGPzAapb8E4nn1szEAAxRlgON77RwUNK8FwZ9tendB
vqCMC8uMSrnTkkVBOOu05bZ4Ip11TmTh7FyQpUb97FyUa2Cq4V2SxbPzGtbU
8amB/zTxtYVPbXw6gaeuAE9dEf+RZOSx2BR+HQTmTdEXo7Db9edImg0Oaz9+
YnoTHf0q4aqDZaLUOhbgPxFKUUWwrFGvSQjENQVLcKZSG8pmKkxdULZgoKoE
dc5UF9EipnqWHShfoM7cp8J8di3iPlCfjsz6AB1gweKAWqI6kQ689qxA/y8l
ukPERrJXy1zr1VlpGqXgro93gAURG5b1fbVUlvcKEOGwWGF9KCKxyMRdpI7W
pKuAjwRVX2muZYcQJBtEA8PlQpzhQJd+9NCstzOCII74YXanRcKWakZjYAwj
IDBSMJxACg+A5HgzOdGII+v/pFpPtzMmJZQ/aQaIMtFzkoDrXmfaUeY2BROp
2uoCFIr0r6b9cTWgRGgIbWGd2Sj+hxiZ1RCrXIFeAIR4g/bxUyWTCQ18AA5E
WAMKnhxbrzh78AMA4F61CbVty3YOLheO+2q1uPaA18lDwpRH3X3gHVKodxSb
Opbxg86AXDBuyH1AGPHxgh8zHTZFVo4s8ohS9KdGpnwhOkaACEbm+3LA8W9C
zRlSMekP+91phBjQ0sQYayvbsWwFzZFcgShW6d6MBanbksRm2+/Vge6Uv1fU
fkLTiBofmdqsPJuB4eD8+qtC+XDyTlK1FZZMX8dRhfXK2VoptSa153vqEhOC
BgJDsjJcgnIjXOggNymvKfsfACU5yWsDWFziwhrCibCSAakB1xDAWBp1HDpT
bAiUNGtlojkRQzuyUJdLkEyqjKLV0Bw5EnE1YKwWppPRDa+FSiGlEqI3Mtep
MYMVKy54PKfksV5FzlBqDfYEExZemCeu4gr0aQm+DkqOfLQwhNNh1hCm1kRp
mVNXewjJDWjwg4hry3HvbQpTlLSPxeMazmW92W4eLbWjBfTwWJNQFoulboCR
v3siX7pdcq9pEEJS8hFePpHacf1YIh8Z9JGzpJquGv7whnP8lMwsE/0k1yE+
LSLz6DSYRjAtGdWKuwLpQAVXJlTQCjcwR595kSxkNQHH75LuQMGoWmFjAYXm
auE9R0b1sjMcjrpgSLClwrw2VOJgeM9twcfCjECMC3TMnLtgUFzkmMtbudMZ
mBOfdqGNrLfa9SrxoRQM8zV0prgaRWK9OSiL0SFPR5HpOGwKSwYTxk4gc9ta
xB1IrNUFSvA06Yu5KT36zDWflzdqwRJ9oZor1VA8u8A0B+IwZUY1Q8VYDWdf
qCXMQ0IEMeeoYo3jEgSLgxGPosfyC3HxNQQBxHfP4ArJ7j7o2qv06IE23InM
sRdr6Tq+INhAYcHRZ1/ivEpq1SUcw9Uc4tJvtxFeg6xHD5B5LKSHLGxeBVH9
oTSyEh2DBHE6cI6kV8m8i7kbPpBMVxSXv0uN6vPRiP5eUdksN8FkYcYmSctc
cwNCD08Xpqb+RCw8P+WPXK9/0bkZTk8Jt+Jt0Jalaz+HhFg8gnGF0v2jA3HX
jM5VUKIoJSHFKCUJSux7XnQOU3hsPT4HnV8sl1nJCB7PBxGeUTg9PA19zHZo
uEhJoQJsxR2FdUwFUMfD7wuIb9cWSslgfj5asvyhb2a+jpkxO8Vkda8/mY5v
utPR2Kucoo8Z6s7mamat1gCCzjH0Jgu6sMCH6iYqA4Y8sNRfIyMKaa3cZHU6
HrDQPRou8UJ/xf0B88CePxD8d1zTBfGr10/nurdhlVA/CbzrYAvgZt0foWIr
kM64d8EcP2tCJA0C8blA7mDZvFDt7zIW1O6EAFhZmWjm0Yk4TITgXmRY6wdO
Rgy8NrZtqU0fE4iFuoqacM+FAwAwamiTg2l1OEl+YZLczC/zmZzZtm/+EvOk
/5/B1KuBEJSFfn4i8z0f8UbyEWAN4G3iPgE5rkUqg8mo8p6VKCMrIUlhViJP
ypm5iQ2N4E93Kw65Gk2J6i+3ozJLmZzbpSDyEL+qRISY1zRMRKTxk9cyN8kQ
rNOn/lqQPKoO8bqY8XSt48xXhvFEIKQN14xkps+IabneEg0qn3y21oYnsXqG
YAjWTrNMvdxm0bduoj3kQtWXqMhbxyR2ALOWGzNtinmEPLitI55nsaz39G+L
TbjRxcW7US0n1duKGtVUAefY0yz4Q5rSVJxv04rGWHk3oPkGFIX1bjt3tp18
x8LcsFRXmen3uuvgzJPerWgpoWnMim4QdY493dzykJZ1A/a3aWMzmHq3tvnW
dl1sMeTlp/aex9T+PybmWi2xQGJOCBNzwsGZ3S53Jni5MyF9EONZM28nj2Fl
+6T3jNnr28FjgW1kxmd5zz9SPT5Qm+L3fb4FxLDeF3ylhCr1SBatqOTzd/0U
6+hl9wMVoPXN7hTagse83uxy9hCl7e9JkV7KHiLhEHuIQCjB/qFmZP9Qvay9
Q+8bdvT3DTvJTSzlh8vvX8J/lYA78SW8Sf1Awv41v4TvEs1rDyrbgGKDRNIi
pAKeH5yhZujor6ipWSisX2BTcBpTec1L8u2vbH/wuhR8Vy+eRFx9szRfn7NP
OI0Wf5cdhq+dSXcwWJu9v0DI8Et4rW0zpokhZt9yDNXVzZM3/mUqh7GdrcUr
yJy+ggxk9LQfZyfuyf7b5aeoRyt2gi96VhTd63ln0ucHRif98Z/9sRwcpDu7
Ho2nMp74O5tMhpejXl/mh/1Sz5iOQedHpvEkC2cX6nc60mcDc0Z/wuvkwXqE
1y6zZPA+th7/5Fs9gVCvfvLkQIdTPPvq4HFGJNk/cXvGomp2anJiad+py09O
3pjfTevRnIC9wCaX6s8/VRv9Opaw85RQNLTM+2gxP1/Zo3erezw/CWM5tJAG
jJQXAGBD6b+cvy34341DezwE5/iFsymoQceJdIlQnAonXi6cnVsQrnScLoe6
ViHQQL5UU6NGx/HDdyhiW2GBfcb7tXfslx3mPBtedNlma4cF8Wc3S3bi0KBd
ZoaR6Z53Evk6OIgMVNorOnAudXPl4MnQ8wH+8+RSNSDxXDdVGwcKWJywU5IT
fYa4ISbDHobWI7W7qkMHM1A+HYw3cFThVwO06lVRkIJQly1GEkf5g0kYuNpv
3pUFPV29H1Pt9jbWPKwIzRjovSxyoEgG0EPRx0Qaz3gGVpT8U/jsGzjshIBa
gOlSWNItWcHzq7xu4dx71fDEvF3UTmYC+7VJHFD0xS8KF45gah5QKzP5ht6Q
bTHwep7ELlYmO3Pq3MaKd7j7QaolkQd3P/zz6mY4/Oxd/iD5lz9I/uUP0oe9
cddfDnfrZDvcdR93zcdd3xt3e0uZB7iF8nC32gVxiyXyLRbF3SiRcako8hKl
3i6K/KRE5PUt1SzkvFUi8qJzvcT5JqZzXhOeR9XEhlAYfb3ZLlH4YjP1Zp/n
pKDeLExBmTOgkWpyng19M9XaPht6MdvgXnl4xbWJ3xD3965i6qgzxB5eYQ2v
sDfW3WOZ/WW9eyxTgo3Nlva2uL0r1rxI2rtmLT574tWZlfzjQiT14H1uwKwA
+cE+PkeybdAOFzwcBHMgmLO67PxHGY/+Pamuw6cTKuQRmlWZQ6iwgVBO5teb
/vgvZTq47I9upmm07jyg2eN5DX2OeufdznFvOPRVuLauw/ur8DsNJdEQbNjY
w5wW1O/1IMbDndBvYW0RFNPwzOqk6oRppT0M6JZGrJ5txHbGnRqn5ciXndEu
z0sXdR1lrg2yFyYHdNS7YN1fk0+KLsLKXHY3ik6xEkOTLfk+CO5M1OHVcoj7
5BDh4M64pRKQZw94duhdgjHJvso1vFLBx38I1d6TAGl/NRezM1xC+1gQjwVJ
EA52nZI/pw4xoV8rZ1IyPb0Db+0t85IHMVJFcZcYeojCC3olUSiaGiwVefZy
/a9Dmkih6HK5zERw0TigXh7uk+ww95Au6SUzIy+ZEapni5vtW5itbHrA6Gcv
9CUEQCdFRV/iB7Za9sc9R3ugC9XD3TyA3HfHLZag4kW/sEknJRrWF1zjtLJn
2yFt28mWLB/ki2Y9GznbD+LhXv/ZhhKMy66oS/i2UM9eYUQWdYdQ7V0xl6DY
teyYZYtYycObyP5JG9J/Yf0eNiFbL6P3yB/KCe6FvowswMuEXGK2Dzok2hcy
wuK2jie0wlKJn7ilbJ97yGXM3t8lXsFnKmn/TyM5P10UpER8Ag6R79oPfxnp
rhwbl611JZjWnfCWEHJlLyeVA7K7E9oSuM2eXwfPVZwUTYuViXvL7ZmHwB3u
tn0R5Pt/7N09wC26KbZMxl9w9VjLnunZLryEVMEuaPfnNn1bYs4ot6R2iWmC
9C15zzPJGkWT7WXufi6aBy1TufZGjbg7ub+w+QtfdOMvoBGTt3rmYggA8YiG
uKZXPnwu9Jadrw1hbudisc7X1CK3c6lY52txYm7ntWjnk/zO29WEzCd5nUeg
t+u8UN9Fum5VG2KrmfjsmNt/osV2SArQ31qjv0cdjV1AAH0/cMh2s81PYPFD
0Rgo1dFgyC3amGtJZEEH2zUPCOj1J93x4Ho6GpP+eDwan5L5ytTk9X7xtzQc
jW0ZorZtrhawJmGPC+dertypMxJcY+T9eEQlymP+xF1b22bKLhUye4dcDMDf
8dq9GU9GY2X613V/7XRcDpFri4NMIlMhixI5ugI6x/2r7l8kaV+SGwvXIpv4
xsKs6pyNhZtnvCRV1zYlZwokArxN12IBZYoAY8/hlTExn/m2rk37nV9x8xvm
uflnrN+O2QtL9//2fmVaGVem1RqJK9O2lHr+dWnbd/KyV6VtSeebvTtlA395
Pf2aV6S5INY5d+TugX9o8f2yNP0NXJYWvQ/ADz095/qxVmU3YDXbn8gYYkiB
DGbykSitZ6yCxiGzGHQCK7wrnnmpEoSLXGSwqS/vJH7UsY+txy5qVsyt+4Vp
ziLifX0wtIrTP/oEjzudkt+Xms1+7S2KBvwPv+mjaxlODFesJmPpvbSpbyNO
Q7sVX5Il+glunGPusCZK1UhDNiPYnVvh3H07VOLawdbvKHQRozFSHqFQ3J7E
yNDG+rKpkyARb/yLEvqPuW7qzgPXtn8sgxs7fLLBAeFtIfyaFLys5JR5AhmN
JV63Bq1W/LKRyLyZRWkAKNQ6nMfhr657preyoQGiYpY5G86zAJ6ZYmY7G/j3
5XzytzHlvQYGPQUQdeEO3nt0vrlXANbvJhBq0nwZIPqrlWGgw43ODJwaAIbR
PPs9/nh2K1oTm8AofhHW/ix4a4jSLrOFd77DdNY4VbHRUpLDFWPglHRHw5vL
K+Wqc9lPnQV7CkJgghBevRhucB3Q75wPUQoFklmvICcAFf4lQbGhKXTxp89y
1q2RQs7vJ859Ug50a2T23Y5Czt2O5cglZK2En3R5K1fQFVwTf/NFnfYdYKfr
Z/8vb25t0na+Dub9humhdfDt3NzKYjrd8S66i4d0QXF2WikKo96ByuD9g3i3
l0FVc7X0YEF9oazLy0K+onNPnbv8CjHoxfYVLxiF6y/d0dVVhAf/NkF/VZEJ
wPtlK31Mdqcsd0PKMjljS8U1rtbhUm4J3Kjt3WwRM+8OsksBTlNf1gGSGUoh
XdZbD0chsQUjmFbM9DhMhT1YxozaTqK/XhJRCuPbi3hden3zB4r5hxcc1cVW
kwBMKJX+VarsGGSU1hgc0PQjEk4RQqzvH/4HUEsDBBQAAAAIADRsYjQQLnXg
3BMAAAGjAAAOAAAAbXlsb2dfMzk4OC5sb2ftHWtz2kjye37F3H4h2cIuSbzt
U6owkCx1xDiA924r5VLJMNiqCImVRBzfr7/uGUnojQTCj5y9VVk06pl+TE93
T89D38SaJNzc6eatqtun9KdjqYr9aDvqrU6VtUWX2k9qE5lUFgvlvPLuGwP/
9m36ddTVdXP+h2osdHpzw8t/hz+iGeTqc/dqqDCAgfGDQOE7D4DQn5oTATgj
63sKcDKpNTtCvV1vQ5Ugqil1AKzrONbNDVEdR5YEoSrtICaAo2caBp07Z4Qa
DrU04+709PRdgOQk0AhFVTKHN7xAFJv1tlt/cKmoIJo5r6aZxhmxqb7MUZPw
P6hNF8AU0YgscNiTj4nI7W/aTeyVJwSQwWfqDI2l+b4mfAiJwC0Pcb/Ektnj
msqt1rtE4LVcEWqnglCpEp0acqNKfqj6hjIab7+oP2VRCuDuW9oParnCC2EP
vdnRAxHYpfe8WusUZesJaOpYQ0Ou9KeXskEfHLpan18P+zL7cfXvvvyT/fnq
am4sr4MU20HsqNB5a4O+WdrtxqFupYorCXx063ugc3P92PXA7TOCKHyYqk0t
4EauVKqLW9Wm+GNj84K1atsPC7nCMMOjaTlYbNv6ylwwSNPQHy2qLvA38qLY
1HGAE5u1p9kqKO8DDtiV6mwsKp+IH5LoB0aD9JdAPH/9ZAxABwUZ4PheOgcF
zWtB8CdT7x7IFwbjyjSCUu62ZFEQzrttuS12pPNuRxbOLwRZatTPL0RZqgnw
d34hyeL5RQ1f1fFXA/9p4mMLf7XxVwd+9QT41RPxH0lGJovp8AuhMEtJn4/E
Xs9TkyQzvH37/gMbOkEFqBI+erBMlFqnAvwnQimOEixr1GsSAvHBgiWorNSC
soUK2gvjze+qKsFhZ6irYBEbfabljz9/RHO3CirtmMS5px4dqe99dIAFi31q
iWoHGnDrswLtv5RoNhEb0VZNI9aqvZnPKQWPfboHLIhYN83vm7WyvlOACJuF
C/GuCIQjU2eV2FvTngJuEkb7Zu6Y1haCpIPMwXY5EGrY0KQbQDQALiUO4ojv
F7fzQORSTakMjGEQBHYKuhNI4TGQHK4mRypxZIOfdN7XrBSlhPLHuQ6ijLQc
JeCq3511laVFwUqqlrqCEUUGl7PBpOpTIjRaDSnObBD/fYjM6harXIFWAIS4
nfb+QyWViTm4AeyI7RsY4dG+dYvTO98HAO5Vi1DLMi376HLhuC83qysXOE4e
EqY8aM49b5DCe1uxqG3qP+gCyAXrhtz7hBEPL7gyw2YqsrFlkQeVYtNVjVT5
QoCMAAGMzP1lgOPflBoLpGI6GA16swAxMEojfTzfWLZpKWiO5AoEskrveiJI
tZokNtteqzY0p/y9odYjmkYc8QHVZuXpDIyGF1dfFcq7kzeSOFph1vR1Ehyw
bjmbLiW+SWz5jjrEgLiBQJdsdIeg3AgXOshNyqrK/gdAUU6y6gAWhzgwjbAD
rKRAzoFriGHMObVtulAsiJXm5sZAcyJu7chKXa9BMokyCr6G6siRiBMCfbMy
7JRm+Ft4KSS8hACOLDWqL2DSinMe1ym5rFeRM5Rag/0ChYWHE9CMer2Ks9DH
NTg7LPLwQh/ORml9mPgmSMySOvP7Lb0+EV4YcWXazp1FQUdJ+1Q8raEya812
82Q9P1lBCw81CYWxWms6WPnbR/K51yN38zmEkZS8h4cPpHZaP5XIewZ9Yq/p
XFN1r3+3Sn5GFqaBjpIPIq4XAUU68/UI9JJRrTgbEA+84KMJR2iFW5iTj7xI
FtKqgOd3SG+oYGStsM6AQmOzcn8HuvVLdzQa98CSYE2FuW14KaCh5r/bgoeF
WYEQF+iZOXd+pzjIMZe3cqsxMDusdwEjWW+ArfKgFAz15+hNcUaKxLpKKIvB
Lk9Gkeo5LArTBgP6TiBLy1yFPUio1ieU4FnUGXNbevKRD323vNOuu1VXqrFR
dcU1DGzoQCCmLOhcVzFYQ+3bDhPmIiGEWHJUocphCYLJwZBH0UI5hoj4mi0Q
3x2DKyS7O79p96VLD9ThXmSJrZhrx/YEwToKC04+ehLnr6S20ME+3CwhMP12
E+DVz3z0AZnLQnLMwvTKj+uPNSIrwT6IEKcB50h6lSx7mL/hHcnGiuLwZ6lR
fToa0eErKtNyA0wWZm2itCznjk/o8enC9NSfiIXnqLwEWX/wqXs9mp0Rbsbb
4LnXjvUUEmIBCQYWSu+PLgReC7pUYRAFKdlSjFKSoMS640UXoMIT8+Ep6Pxs
OsxKBvC4PojwrMLZ8WkYYMZjjrOUBCrAVtxSmMhUAHU4/v4EAW5sphSN5pfj
Ncshembm64QZszNMWPcH09nkujcbT9yXM/QxI83e/ZpZqxiA3zjG3mRFVyb4
UM3AwYAxD0z2Y2QEIc2NE32djAcsdJ9u53hbg8v9AfPArj/wn3FS5wewbjvd
q/6uaUKj5bn94W7gZq3p9VCxKUh30v/EHD+rQlgkvhTILcybV6r1XcaC2q3g
AysbA808OhGbiRDciwyTfd/JiL7XxrottenZchALdRQ14p4LBwBg1NAm+2p1
PEl+ZpLczS/zmZzZtte/ET0Z/Gc4c99ACMpCPy+Z+ZaQeCUJCbAG8DR1HoEc
xySV4XRceUtLlJGWkKRtWiJLyqnJiR2V4E9zKja5HM+I6s23gzJLUM58OYgs
xC8qEyFmVd1mIpL4yaqZmWXw5+kzby5IHlSbuE0seL7WtpcbXX8kENJu54xk
oS2IYTruFA1ePnpsxbonMnuGYAjmTovUcZln0hc30S5y1ySAREVeOySxI5i1
zJhpV8wTa2SviOdJLOsd/dtkCjf+9OnNqJaT620FjWqigDPsaRr8MU1pIs7X
aUVDrLwZ0GwDisJ6s517206+a2Gpm6qjLLQ7zbFR86Q3K1pKaBqyojtEnWFP
d9c8pmXdgf112tgUpt6sbba1jYsthLz81N7TmNr/x8RcqyUWSMwJ28SccHRm
8+XOBDd3JiR3Yjhr5m7l0c10n/SWMXt5W3hMsI3M+Kzv+CLVwz21KC7w8z0g
uvk24SslVKkHsmhFJZ+97adYQ8+7IagAra92q1AOHrNas8rZRJS0wSdBegmb
iIRjbCICofgbiJqBDUSl7R1627CjvW3YiW5iKT9cflsJ/1UC7shKeJN6LFu/
5kr4PtH8/F5lG1AskEhShFTA84MznOsa+itqzE0U1i+wKziJqazqJfn2F7ZB
OC4Fz9WLnYCrbz7FPuEkWrxddhi+dqe94TCmvb9AyPBLeK28GdNIF7O1HF11
NKPzylemMhjb21q8gMzpC8hABo/7cXbCnuy/PX6SerxhR/iC50XRvV50pwN+
aHQ6mPw5mMj+Sbrzq/FkJuORv/PpdPRl3B/I/LRf4jnTCYz5saE/ysL5J/U7
HWuLobGgP+Fxem8+wGOPWTJ4npgPf/KtnkCo+376aEODMzz/auN5RiTZO3V7
zqJqdm5yas6/U4efnbw2vhvmgzEFe4FVvqg//1Qt9OtYwk5UQtHINO5CxfyE
ZZ/ebu7wBCV05shEIjBUXgGEBaX/sv824X/XNu3zGJwTIJzPYBx07UCbCMXJ
sMPlwvmFCfFK1+5xqCsVIg1kTDXmVO/aXvwORWwvLPDPmL9yz/6y45zno089
ttvaZlH8+fWanTnUaY/ZYeS67x5HvvJPIwOV1oYO7S+asbHxbOjFEP95dKjq
k3ihGaqFPQUsTtk5yam2QNwQlGELI/OBWj3VpsMFjD4NrDdwVOH3A7QaVVGQ
vLkLn41EzvP7Wuj72m/uvQV9Tb2b0PnNTaj69sXWjsHAl0UOFEgBuigGmEnj
KU/fjJJ/Ch89C4eNEBgXYLsUlnWLvuAJVv5uZd+5r+EXc3dBQ5kK7L2N4oCi
z17RduYItuYeh2Uq39Aasi36bs+V2KeNwU6d2jeh4j0ugJBqUeT+BRD/vLwe
jT66N0BI3g0QkncDhPTuYNz158Pd6uTDXfdw1zzc9YNxt3PK3MctlIe71S6I
WyyRb7Eo7kaJjEtFkZco9XZR5J0SkddzDrMt560SkRfV9RL1TUzmvCY8zVAT
G0Jh9PVmu0Thi83E632ekoJ6szAFZWpAI9HkPBn6ZqK1fTL0YrrBvXTxijHF
b4iHe1cxsdcZYhevEMMrHIx1/1jmcFnvH8uUYGPTpZ0Xt3vPmhtJu3ethbUn
/Dr1JV9dCOQe3PUGTAuQH2z1OZBug3o44eEgmATBpNWX7n+Uyfjf02ocPplQ
IYvQtJcZhAo7COVkfr0eTP5SZsMvg/H1LInWvTs0vT+voM1x/6LXPe2PRt4Q
rsXH8OFD+I2Gkmgo4Za+nHGzFMcdHDafY+NbiE2CQiM89XV06GzzSgcY0JxG
rJ5uxPbGnRinZciXHdIuz0sXdR1lzg3SJyZHdNT7YD18JHeKTsLKnHY3iqpY
iaFJTr6PgjsV9fZyOcTdOUY4uDduqQTk6R2eHnqXYEzS73Pd3qng4T/G0D6Q
AOnwYS6mZ7iE9qkgngqSIBztPiVPp46h0C+VMymant6Dt3bOvORRjFRR3CWG
HqLwjF5JFIqmBktFnj5d/+uYJlIoOl0uMxFcNA6ol4e7kx7mHtMlPWdm5Dkz
QvV0cbONC4uNRY8Y/RyEvoQAqFNU9CUusNXSF/fs+T1dqS7u5hHkvj9usYQh
XnSFTeqUaFifcY7TSte2Y9q2Tk6Wj7KiWU9HzvaDuLjj324owbjsi7qEtYV6
+gwjMKk7xtDeF3MJA7uWHrPkiJVcvJHsn7Qj/bd9f4BNSB+XwZvkj+UED0Jf
RhbgeUIuMd0HHRPtMxlhMa/j2VphqcQlbind5x5zGnPwusQLWKaSDl8ayfh+
kZ8S8Qg4Rr7rMPxlpLsybFz6qCvBtO6Ft4SQK306qRyR3b3QlsBtun4dPVfR
KZoWKxN3zu2Zx8C93W37LMgPX+zdP8Atuim2TMafcfZYS9f0dBdeQqpgH7SH
c5u8LTGjl1tSu8Q0QfKWvKdRskbRZHuZu5+L5kHLHFwHo0bc3czPbP7CN914
E2jE5M6euRh8QDyiIcbGlQefCZ2z8VgXZjYuFms8NiwyG5eKNR6LEzMbrwUb
n2Y33q5GZD7NajwAna/xQm0XabpVrdWEjlQXCmCI1cmHqBCGaNN9as/ZLQTQ
9r17Zr8u8FNY/GQ0Bkt1NBqyuGwvgcIoOr+JvA34RPQH095keDUbT8hgMhlP
zshyY8zleMv4UQ17zrYOUcsyNiuYm7CfK/tOrtyqC+LfZ+R+RaIS5DNbgWNz
3FT5JUKm75QLAXg7X3vXk+l4osz+uhrETsllEBmbJKQSmQhZlMjxJdA5GVz2
/iJROxPdYBiLcMIbDNNeZ2ww3K31klSNbU5OFUgAOE/TYoEBFQDGlrd3x4R8
5+u6P+13ftfNb5jv5stZv52yB5b2/+3t7rQy7k6rNSJ3p+WUeva9afkbed47
03LS+WovUdnBX1ZLv+ZdaQ6IdckduXPsTy6+XZumvYJr04IXA3jxp+td39eq
rmn5QCYQRgpkuJBPRCmeuvIrb5nFuBNY4U3xFEyVIFzgRoNdbblH8oOefWI+
9HBohfy6V5jkLQLu1wNDszj7Y0Dw3NMZ+X09t9h334JowAHxOz96pm6HcIXe
pMzB1xb1jMTZ1nCF52aRdvy755hudNr1aqAi0wh2+9ZWd18PlTh5sLRbCk2E
aAyUBygU85MY6NpQWxa1IyTi3X9BQv+x1AzNvuej7R9r/+oOj2zwQHhtCL8w
Ba8tOWOuQEZriRevQa0Nv3UkoDeLIA0AhaMO9Xj7AXbX9lZ2VEBUzDSnw7kW
wDVT3G6nQ/++Xk7/1me8Wd+iJwDiYLiF5z5dZjMGgNrtFAJNuhNuebnRdXS3
QbVAvQAwjOXZh/nDOa7gm5D2ouxFIrZZ6NYQpX1UhTe+hy7POVWhrlKifRVi
4Iz0xqPrL5fKZffLIFEFDhNEjclBeHlS2Gv8JLLMsLBQ/c4JXsJ5oAYJL1Vy
Ef25xunToHsxQvUpkAt8FamUF0LkjjREjSUDa0Lk5EJmNiJWJx+iAvmOWqEk
aJFUShpwurgTD5ZPBrPJcPDnQMH5fzX9dHk22fmTS2nAJZEd8lzPuDgjtaW2
J8LCizPByrkXZ4KVMgc1A8y9OBOHztl4nsWZOHTOxvMszsShczaeZ3EmDp05
UDi4UI0vBqS2nQacc6Bk38fgN+1KZI/1Uyl9Y8RvR1ypr6ev27pY41vKStgN
ERsqO1aLm/4hpcO3s9X2XiUvAXfRg9KlMl50/0sC8sPizxbXY6nz8iLQAzlr
Ms6ajV+NMan2YhkL0X9G8D5ZZYZzBn/eWc50U5JelQiOO/cWX+zkG9nybrcN
cVTokxWeoUv73oGQ8eX/pefVrON87yD9qwRCxlcJypHLlrUSPkb6Wi5PL7iI
+80TddIcKVvaLEaNfzgl5ZsjLnSJ3xyR2g0/NNn5pQwA7hT45ojUbomBYRX5
5kjrVo18c2TRPPJH/vZmtuzPghygMJHhuUNhvM0Wv+ZHapq0nV9hntpov4qP
1NSkepsvWmm2e6f/DS/kurgtjkyUU2DUW7Cx+KkFvMVcp6qxWbuwYO+hrMfL
tny5usdA1KXDL0uHVizHLfR74epzb3x5GeCBeBDusmkqAG+X7WXA7Xz+qr1f
O0BZKmdsLTzGVRwu/EEELt/YaA/UxfJeuohZFAWySwCODN+ttJDMrRSSZZ27
OwqJze/BpGI2jrebfe5NfUEtO9JeP4oogfH8Io5Lb2D8QDH/cIPQerveJgCz
lcrgMlF2DDJIawgOaPrBw1YGQAgxv7/7H1BLAQIUABQAAAAIADRsYjROuatq
0hMAAO6iAAAQAAAAAAAAAAEAIAAAAAAAAABteWxvZ18zOTg4XzIubG9nUEsB
AhQAFAAAAAgANGxiNCDI+AOTEgAAjpIAAA4AAAAAAAAAAQAgAAAAABQAAG15
bG9nXzQxNzIubG9nUEsBAhQAFAAAAAgANGxiNGR3sI9+EgAAEpIAAA4AAAAA
AAAAAQAgAAAAvyYAAG15bG9nXzU5NjgubG9nUEsBAhQAFAAAAAgANGxiNBAu
deDcEwAAAaMAAA4AAAAAAAAAAQAgAAAAaTkAAG15bG9nXzM5ODgubG9nUEsF
BgAAAAAEAAQA8gAAAHFNAAAAAA==

------_=_NextPart_001_01C63E30.93303F02
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


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

http://archives.postgresql.org

------_=_NextPart_001_01C63E30.93303F02--

Visual Studio Query Builder filter

Apologies if this is largely a Visual Studio 2005 question. I'm posting
it here because I assume my problem is caused by the interaction between
psqlODBC and Visual Studio. I'm using psqlODBC 8.01.02.00.

When using the graphical Query Builder tool, you can specify a filter
for your query. For example, if you specify the filter for table column
x as " = sometext' then you get:
WHERE x = 'sometext'
in your query.

All well and good if the column is of type text, but if the column is of
type Boolean I can't figure out how to get the damn thing to accept my
filter. For example:
" = 't'"
" = t"
" = true"
etc...
all don't work, saying that the data is of the wrong type.

Ok, so you're wondering why I don't just write my query the good old
fashioned way? The problem is if the Query Builder doesn't like your
query, it spits the dummy when it tries to generate the FillBy and GetBy
queries needed to use VS 2005 TableAdaptors.

The only workaround I've found so far is to create a dummy function that
always returns true and use that in the filter, eg.
" = alwaysTrue(12345)"

Any ideas on how to get it to accept my filter as boolean so I don't
have to use this workaround?

Regards,

Patrick

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Visual Studio Query Builder filter

Actually, the Query Builder seems to be almost completely broken with
version 8.01.02.00. In previous versions I could use it to define simple
filters etc..

With 8.01.02.00 I can only use the Query Builder to generate a
bare-bones SELECT/INSERT/... I found I can then close the generate
wizard and make a more advanced query by hand in the properties window
without everything breaking. Walking on tip-toes though!

Patrick

PS. Sorry, it's probably not so much the fault of psqlODBC developers as
the result of having to fit the Microsoft mould...
> Apologies if this is largely a Visual Studio 2005 question. I'm
> posting it here because I assume my problem is caused by the
> interaction between psqlODBC and Visual Studio. I'm using psqlODBC
> 8.01.02.00.
>
> When using the graphical Query Builder tool, you can specify a filter
> for your query. For example, if you specify the filter for table
> column x as " = sometext' then you get:
> WHERE x = 'sometext'
> in your query.
>
> All well and good if the column is of type text, but if the column is
> of type Boolean I can't figure out how to get the damn thing to accept
> my filter. For example:
> " = 't'"
> " = t"
> " = true"
> etc...
> all don't work, saying that the data is of the wrong type.
>
> Ok, so you're wondering why I don't just write my query the good old
> fashioned way? The problem is if the Query Builder doesn't like your
> query, it spits the dummy when it tries to generate the FillBy and
> GetBy queries needed to use VS 2005 TableAdaptors.
>
> The only workaround I've found so far is to create a dummy function
> that always returns true and use that in the filter, eg.
> " = alwaysTrue(12345)"
>
> Any ideas on how to get it to accept my filter as boolean so I don't
> have to use this workaround?
>
> Regards,
>
> Patrick
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match


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

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