With the promised files this time.
On Sat, 23 Apr 2005, Kris Jurka wrote:
>
> The 8.1 server doesn't work when issuing queries using the v2 protocol,
> notably the isnull bitmask in the DataRow message is incorrect. I suspect
> the problem is with this commit:
>
> http://archives.postgresql.org/pgsql-committers/2005-03/msg00224.php
>
> I've attached the tcpdump output from establishing a connection with the
> JDBC driver using the V2 protocol to a 7.4 and an 8.1 server. In the 7.4
> server after the 'D' message is c0 while 8.1 has 00 as the next byte.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
22:20:05.430250 IP localhost.51539 > localhost.postgresql: S
2034505391:2034505391(0) win 32767 <mss 16396,sackOK,timestamp 3743595316
0,nop,wscale 2>
0x0000: 4500 003c ad9b 4000 4006 8f1e 7f00 0001 E..<[EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 16af 0000 0000 .....S.8yD......
0x0020: a002 7fff 86d4 0000 0204 400c 0402 080a [EMAIL PROTECTED]
0x0030: df22 bb34 0000 0000 0103 0302 .".4........
22:20:05.430304 IP localhost.postgresql > localhost.51539: S
2038983743:2038983743(0) ack 2034505392 win 32767 <mss 16396,sackOK,timestamp
3743595316 3743595316,nop,wscale 2>
0x0000: 4500 003c 0000 4000 4006 3cba 7f00 0001 E..<[EMAIL
PROTECTED]@.<.....
0x0010: 7f00 0001 1538 c953 7988 6c3f 7944 16b0 .....8.Sy.l?yD..
0x0020: a012 7fff 06a4 0000 0204 400c 0402 080a [EMAIL PROTECTED]
0x0030: df22 bb34 df22 bb34 0103 0302 .".4.".4....
22:20:05.430345 IP localhost.51539 > localhost.postgresql: . ack 1 win 8192
<nop,nop,timestamp 3743595316 3743595316>
0x0000: 4500 0034 ad9d 4000 4006 8f24 7f00 0001 [EMAIL
PROTECTED]@..$....
0x0010: 7f00 0001 c953 1538 7944 16b0 7988 6c40 .....S.8yD..y.l@
0x0020: 8010 2000 cfc2 0000 0101 080a df22 bb34 .............".4
0x0030: df22 bb34 .".4
22:20:05.457987 IP localhost.51539 > localhost.postgresql: P 1:297(296) ack 1
win 8192 <nop,nop,timestamp 3743595344 3743595316>
0x0000: 4500 015c ad9f 4000 4006 8dfa 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 16b0 7988 6c40 .....S.8yD..y.l@
0x0020: 8018 2000 ff50 0000 0101 080a df22 bb50 .....P.......".P
0x0030: df22 bb34 0000 0128 0002 0000 6a75 726b .".4...(....jurk
0x0040: 6100 0000 0000 0000 0000 0000 0000 0000 a...............
0x0050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0060: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0070: 0000 0000 0000 0000 0000 0000 6a75 726b ............jurk
0x0080: 6100 0000 0000 0000 0000 0000 0000 0000 a...............
0x0090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00c0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00d0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00e0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00f0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0100: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0110: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0120: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0130: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0140: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0150: 0000 0000 0000 0000 0000 0000 ............
22:20:05.458485 IP localhost.postgresql > localhost.51539: . ack 297 win 8192
<nop,nop,timestamp 3743595344 3743595344>
0x0000: 4500 0034 d774 4000 4006 654d 7f00 0001 [EMAIL
PROTECTED]@.eM....
0x0010: 7f00 0001 1538 c953 7988 6c40 7944 17d8 [EMAIL PROTECTED]
0x0020: 8010 2000 ce62 0000 0101 080a df22 bb50 .....b.......".P
0x0030: df22 bb50 .".P
22:20:05.462500 IP localhost.postgresql > localhost.51539: P 1:16(15) ack 297
win 8192 <nop,nop,timestamp 3743595348 3743595344>
0x0000: 4500 0043 d776 4000 4006 653c 7f00 0001 [EMAIL
PROTECTED]@.e<....
0x0010: 7f00 0001 1538 c953 7988 6c40 7944 17d8 [EMAIL PROTECTED]
0x0020: 8018 2000 fe37 0000 0101 080a df22 bb54 .....7.......".T
0x0030: df22 bb50 5200 0000 004b 0000 732f 371a .".PR....K..s/7.
0x0040: 0f42 5a .BZ
22:20:05.462556 IP localhost.51539 > localhost.postgresql: . ack 16 win 8192
<nop,nop,timestamp 3743595348 3743595348>
0x0000: 4500 0034 ada1 4000 4006 8f20 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 17d8 7988 6c4f .....S.8yD..y.lO
0x0020: 8010 2000 ce4b 0000 0101 080a df22 bb54 .....K.......".T
0x0030: df22 bb54 .".T
22:20:05.498616 IP localhost.51539 > localhost.postgresql: P 297:432(135) ack
16 win 8192 <nop,nop,timestamp 3743595384 3743595348>
0x0000: 4500 00bb ada3 4000 4006 8e97 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 17d8 7988 6c4f .....S.8yD..y.lO
0x0020: 8018 2000 feaf 0000 0101 080a df22 bb78 .............".x
0x0030: df22 bb54 5173 6574 2064 6174 6573 7479 .".TQset.datesty
0x0040: 6c65 203d 2027 4953 4f27 3b20 7365 6c65 le.=.'ISO';.sele
0x0050: 6374 2076 6572 7369 6f6e 2829 2c20 6361 ct.version(),.ca
0x0060: 7365 2077 6865 6e20 7067 5f65 6e63 6f64 se.when.pg_encod
0x0070: 696e 675f 746f 5f63 6861 7228 3129 203d ing_to_char(1).=
0x0080: 2027 5351 4c5f 4153 4349 4927 2074 6865 .'SQL_ASCII'.the
0x0090: 6e20 2755 4e4b 4e4f 574e 2720 656c 7365 n.'UNKNOWN'.else
0x00a0: 2067 6574 6461 7461 6261 7365 656e 636f .getdatabaseenco
0x00b0: 6469 6e67 2829 2065 6e64 00 ding().end.
22:20:05.502711 IP localhost.postgresql > localhost.51539: P 16:207(191) ack
432 win 8192 <nop,nop,timestamp 3743595388 3743595384>
0x0000: 4500 00f3 d778 4000 4006 648a 7f00 0001 [EMAIL
PROTECTED]@.d.....
0x0010: 7f00 0001 1538 c953 7988 6c4f 7944 185f .....8.Sy.lOyD._
0x0020: 8018 2000 fee7 0000 0101 080a df22 bb7c .............".|
0x0030: df22 bb78 4353 4554 0050 626c 616e 6b00 .".xCSET.Pblank.
0x0040: 5400 0276 6572 7369 6f6e 0000 0000 19ff T..version......
0x0050: ffff ffff ff67 6574 6461 7461 6261 7365 .....getdatabase
0x0060: 656e 636f 6469 6e67 0000 0000 1300 40ff [EMAIL PROTECTED]
0x0070: ffff ff44 c000 0000 6850 6f73 7467 7265 ...D....hPostgre
0x0080: 5351 4c20 372e 342e 3720 6f6e 2069 3338 SQL.7.4.7.on.i38
0x0090: 362d 7063 2d6c 696e 7578 2d67 6e75 2c20 6-pc-linux-gnu,.
0x00a0: 636f 6d70 696c 6564 2062 7920 4743 4320 compiled.by.GCC.
0x00b0: 6933 3836 2d6c 696e 7578 2d67 6363 2028 i386-linux-gcc.(
0x00c0: 4743 4329 2033 2e33 2e35 2028 4465 6269 GCC).3.3.5.(Debi
0x00d0: 616e 2031 3a33 2e33 2e35 2d38 2900 0000 an.1:3.3.5-8)...
0x00e0: 0d53 514c 5f41 5343 4949 4353 454c 4543 .SQL_ASCIICSELEC
0x00f0: 5400 5a T.Z
22:20:05.523958 IP localhost.51539 > localhost.postgresql: P 432:501(69) ack
207 win 8192 <nop,nop,timestamp 3743595410 3743595388>
0x0000: 4500 0079 ada5 4000 4006 8ed7 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 185f 7988 6d0e .....S.8yD._y.m.
0x0020: 8018 2000 fe6d 0000 0101 080a df22 bb92 .....m......."..
0x0030: df22 bb7c 5162 6567 696e 3b20 7365 7420 .".|Qbegin;.set.
0x0040: 6175 746f 636f 6d6d 6974 203d 206f 6e3b autocommit.=.on;
0x0050: 2073 6574 2063 6c69 656e 745f 656e 636f .set.client_enco
0x0060: 6469 6e67 203d 2027 554e 4943 4f44 4527 ding.=.'UNICODE'
0x0070: 3b20 636f 6d6d 6974 00 ;.commit.
22:20:05.524811 IP localhost.postgresql > localhost.51539: P 207:233(26) ack
501 win 8192 <nop,nop,timestamp 3743595411 3743595410>
0x0000: 4500 004e d77a 4000 4006 652d 7f00 0001 [EMAIL
PROTECTED]@.e-....
0x0010: 7f00 0001 1538 c953 7988 6d0e 7944 18a4 .....8.Sy.m.yD..
0x0020: 8018 2000 fe42 0000 0101 080a df22 bb93 .....B......."..
0x0030: df22 bb92 4342 4547 494e 0043 5345 5400 ."..CBEGIN.CSET.
0x0040: 4353 4554 0043 434f 4d4d 4954 005a CSET.CCOMMIT.Z
22:20:05.565669 IP localhost.51539 > localhost.postgresql: . ack 233 win 8192
<nop,nop,timestamp 3743595451 3743595411>
0x0000: 4500 0034 ada7 4000 4006 8f1a 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18a4 7988 6d28 .....S.8yD..y.m(
0x0020: 8010 2000 cc00 0000 0101 080a df22 bbbb ............."..
0x0030: df22 bb93 ."..
22:20:05.627010 IP localhost.51539 > localhost.postgresql: P 501:511(10) ack
233 win 8192 <nop,nop,timestamp 3743595513 3743595411>
0x0000: 4500 003e ada9 4000 4006 8f0e 7f00 0001 E..>[EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18a4 7988 6d28 .....S.8yD..y.m(
0x0020: 8018 2000 fe32 0000 0101 080a df22 bbf9 .....2......."..
0x0030: df22 bb93 5153 454c 4543 5420 3100 ."..QSELECT.1.
22:20:05.627810 IP localhost.postgresql > localhost.51539: P 233:278(45) ack
511 win 8192 <nop,nop,timestamp 3743595514 3743595513>
0x0000: 4500 0061 d77c 4000 4006 6518 7f00 0001 E..a.|@[EMAIL
PROTECTED]
0x0010: 7f00 0001 1538 c953 7988 6d28 7944 18ae .....8.Sy.m(yD..
0x0020: 8018 2000 fe55 0000 0101 080a df22 bbfa .....U......."..
0x0030: df22 bbf9 5062 6c61 6e6b 0054 0001 3f63 ."..Pblank.T..?c
0x0040: 6f6c 756d 6e3f 0000 0000 1700 04ff ffff olumn?..........
0x0050: ff44 8000 0000 0531 4353 454c 4543 5400 .D.....1CSELECT.
0x0060: 5a Z
22:20:05.627869 IP localhost.51539 > localhost.postgresql: . ack 278 win 8192
<nop,nop,timestamp 3743595514 3743595514>
0x0000: 4500 0034 adab 4000 4006 8f16 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18ae 7988 6d55 .....S.8yD..y.mU
0x0020: 8010 2000 cb23 0000 0101 080a df22 bbfa .....#......."..
0x0030: df22 bbfa ."..
22:20:05.692920 IP localhost.51539 > localhost.postgresql: P 511:527(16) ack
278 win 8192 <nop,nop,timestamp 3743595579 3743595514>
0x0000: 4500 0044 adad 4000 4006 8f04 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18ae 7988 6d55 .....S.8yD..y.mU
0x0020: 8018 2000 fe38 0000 0101 080a df22 bc3b .....8.......".;
0x0030: df22 bbfa 5142 4547 494e 3b53 454c 4543 ."..QBEGIN;SELEC
0x0040: 5420 3100 T.1.
22:20:05.693542 IP localhost.postgresql > localhost.51539: P 278:330(52) ack
527 win 8192 <nop,nop,timestamp 3743595579 3743595579>
0x0000: 4500 0068 d77e 4000 4006 650f 7f00 0001 [EMAIL
PROTECTED]@.e.....
0x0010: 7f00 0001 1538 c953 7988 6d55 7944 18be .....8.Sy.mUyD..
0x0020: 8018 2000 fe5c 0000 0101 080a df22 bc3b .....\.......".;
0x0030: df22 bc3b 4342 4547 494e 0050 626c 616e .".;CBEGIN.Pblan
0x0040: 6b00 5400 013f 636f 6c75 6d6e 3f00 0000 k.T..?column?...
0x0050: 0017 0004 ffff ffff 4480 0000 0005 3143 ........D.....1C
0x0060: 5345 4c45 4354 005a SELECT.Z
22:20:05.693659 IP localhost.51539 > localhost.postgresql: . ack 330 win 8192
<nop,nop,timestamp 3743595579 3743595579>
0x0000: 4500 0034 adaf 4000 4006 8f12 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18be 7988 6d89 .....S.8yD..y.m.
0x0020: 8010 2000 ca5d 0000 0101 080a df22 bc3b .....].......".;
0x0030: df22 bc3b .".;
22:20:05.698562 IP localhost.51539 > localhost.postgresql: P 527:535(8) ack 330
win 8192 <nop,nop,timestamp 3743595584 3743595579>
0x0000: 4500 003c adb1 4000 4006 8f08 7f00 0001 E..<[EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18be 7988 6d89 .....S.8yD..y.m.
0x0020: 8018 2000 fe30 0000 0101 080a df22 bc40 .....0.......".@
0x0030: df22 bc3b 5143 4f4d 4d49 5400 .".;QCOMMIT.
22:20:05.699042 IP localhost.postgresql > localhost.51539: P 330:339(9) ack 535
win 8192 <nop,nop,timestamp 3743595585 3743595584>
0x0000: 4500 003d d780 4000 4006 6538 7f00 0001 [EMAIL
PROTECTED]@.e8....
0x0010: 7f00 0001 1538 c953 7988 6d89 7944 18c6 .....8.Sy.m.yD..
0x0020: 8018 2000 fe31 0000 0101 080a df22 bc41 .....1.......".A
0x0030: df22 bc40 4343 4f4d 4d49 5400 5a ."[EMAIL PROTECTED]
22:20:05.699688 IP localhost.51539 > localhost.postgresql: P 535:551(16) ack
339 win 8192 <nop,nop,timestamp 3743595585 3743595585>
0x0000: 4500 0044 adb3 4000 4006 8efe 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18c6 7988 6d92 .....S.8yD..y.m.
0x0020: 8018 2000 fe38 0000 0101 080a df22 bc41 .....8.......".A
0x0030: df22 bc41 5142 4547 494e 3b53 454c 4543 .".AQBEGIN;SELEC
0x0040: 5420 3100 T.1.
22:20:05.700149 IP localhost.postgresql > localhost.51539: P 339:391(52) ack
551 win 8192 <nop,nop,timestamp 3743595586 3743595585>
0x0000: 4500 0068 d782 4000 4006 650b 7f00 0001 [EMAIL
PROTECTED]@.e.....
0x0010: 7f00 0001 1538 c953 7988 6d92 7944 18d6 .....8.Sy.m.yD..
0x0020: 8018 2000 fe5c 0000 0101 080a df22 bc42 .....\.......".B
0x0030: df22 bc41 4342 4547 494e 0050 626c 616e .".ACBEGIN.Pblan
0x0040: 6b00 5400 013f 636f 6c75 6d6e 3f00 0000 k.T..?column?...
0x0050: 0017 0004 ffff ffff 4480 0000 0005 3143 ........D.....1C
0x0060: 5345 4c45 4354 005a SELECT.Z
22:20:05.702676 IP localhost.51539 > localhost.postgresql: P 551:559(8) ack 391
win 8192 <nop,nop,timestamp 3743595588 3743595586>
0x0000: 4500 003c adb5 4000 4006 8f04 7f00 0001 E..<[EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18d6 7988 6dc6 .....S.8yD..y.m.
0x0020: 8018 2000 fe30 0000 0101 080a df22 bc44 .....0.......".D
0x0030: df22 bc42 5143 4f4d 4d49 5400 .".BQCOMMIT.
22:20:05.703115 IP localhost.postgresql > localhost.51539: P 391:400(9) ack 559
win 8192 <nop,nop,timestamp 3743595589 3743595588>
0x0000: 4500 003d d784 4000 4006 6534 7f00 0001 [EMAIL
PROTECTED]@.e4....
0x0010: 7f00 0001 1538 c953 7988 6dc6 7944 18de .....8.Sy.m.yD..
0x0020: 8018 2000 fe31 0000 0101 080a df22 bc45 .....1.......".E
0x0030: df22 bc44 4343 4f4d 4d49 5400 5a .".DCCOMMIT.Z
22:20:05.704105 IP localhost.51539 > localhost.postgresql: P 559:560(1) ack 400
win 8192 <nop,nop,timestamp 3743595590 3743595589>
0x0000: 4500 0035 adb7 4000 4006 8f09 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18de 7988 6dcf .....S.8yD..y.m.
0x0020: 8018 2000 fe29 0000 0101 080a df22 bc46 .....).......".F
0x0030: df22 bc45 58 .".EX
22:20:05.705768 IP localhost.postgresql > localhost.51539: F 400:400(0) ack 560
win 8192 <nop,nop,timestamp 3743595592 3743595590>
0x0000: 4500 0034 d786 4000 4006 653b 7f00 0001 [EMAIL
PROTECTED]@.e;....
0x0010: 7f00 0001 1538 c953 7988 6dcf 7944 18df .....8.Sy.m.yD..
0x0020: 8011 2000 c9dd 0000 0101 080a df22 bc48 .............".H
0x0030: df22 bc46 .".F
22:20:05.706838 IP localhost.51539 > localhost.postgresql: F 560:560(0) ack 401
win 8192 <nop,nop,timestamp 3743595593 3743595592>
0x0000: 4500 0034 adb9 4000 4006 8f08 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 c953 1538 7944 18df 7988 6dd0 .....S.8yD..y.m.
0x0020: 8011 2000 c9d9 0000 0101 080a df22 bc49 .............".I
0x0030: df22 bc48 .".H
22:20:05.706884 IP localhost.postgresql > localhost.51539: . ack 561 win 8192
<nop,nop,timestamp 3743595593 3743595593>
0x0000: 4500 0034 d788 4000 4006 6539 7f00 0001 [EMAIL
PROTECTED]@.e9....
0x0010: 7f00 0001 1538 c953 7988 6dd0 7944 18e0 .....8.Sy.m.yD..
0x0020: 8010 2000 c9d8 0000 0101 080a df22 bc49 .............".I
0x0030: df22 bc49 .".I
22:20:15.394171 IP localhost.51542 > localhost.5810: S 2052003431:2052003431(0)
win 32767 <mss 16396,sackOK,timestamp 3743605281 0,nop,wscale 2>
0x0000: 4500 003c f446 4000 4006 4873 7f00 0001 E..<[EMAIL
PROTECTED]@.Hs....
0x0010: 7f00 0001 c956 16b2 7a4f 1667 0000 0000 .....V..zO.g....
0x0020: a002 7fff 5da7 0000 0204 400c 0402 080a [EMAIL PROTECTED]
0x0030: df22 e221 0000 0000 0103 0302 .".!........
22:20:15.394208 IP localhost.5810 > localhost.51542: S 2054448764:2054448764(0)
ack 2052003432 win 32767 <mss 16396,sackOK,timestamp 3743605281
3743605281,nop,wscale 2>
0x0000: 4500 003c 0000 4000 4006 3cba 7f00 0001 E..<[EMAIL
PROTECTED]@.<.....
0x0010: 7f00 0001 16b2 c956 7a74 667c 7a4f 1668 .......Vztf|zO.h
0x0020: a012 7fff bb60 0000 0204 400c 0402 080a [EMAIL PROTECTED]
0x0030: df22 e221 df22 e221 0103 0302 .".!.".!....
22:20:15.394235 IP localhost.51542 > localhost.5810: . ack 1 win 8192
<nop,nop,timestamp 3743605281 3743605281>
0x0000: 4500 0034 f448 4000 4006 4879 7f00 0001 [EMAIL
PROTECTED]@.Hy....
0x0010: 7f00 0001 c956 16b2 7a4f 1668 7a74 667d .....V..zO.hztf}
0x0020: 8010 2000 847f 0000 0101 080a df22 e221 .............".!
0x0030: df22 e221 .".!
22:20:15.423875 IP localhost.51542 > localhost.5810: P 1:297(296) ack 1 win
8192 <nop,nop,timestamp 3743605311 3743605281>
0x0000: 4500 015c f44a 4000 4006 474f 7f00 0001 [EMAIL
PROTECTED]@.GO....
0x0010: 7f00 0001 c956 16b2 7a4f 1668 7a74 667d .....V..zO.hztf}
0x0020: 8018 2000 ff50 0000 0101 080a df22 e23f .....P.......".?
0x0030: df22 e221 0000 0128 0002 0000 6a75 726b .".!...(....jurk
0x0040: 6100 0000 0000 0000 0000 0000 0000 0000 a...............
0x0050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0060: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0070: 0000 0000 0000 0000 0000 0000 6a75 726b ............jurk
0x0080: 6100 0000 0000 0000 0000 0000 0000 0000 a...............
0x0090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00c0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00d0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00e0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00f0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0100: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0110: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0120: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0130: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0140: 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0150: 0000 0000 0000 0000 0000 0000 ............
22:20:15.424273 IP localhost.5810 > localhost.51542: . ack 297 win 8192
<nop,nop,timestamp 3743605311 3743605311>
0x0000: 4500 0034 845c 4000 4006 b865 7f00 0001 [EMAIL
PROTECTED]@..e....
0x0010: 7f00 0001 16b2 c956 7a74 667d 7a4f 1790 .......Vztf}zO..
0x0020: 8010 2000 831b 0000 0101 080a df22 e23f .............".?
0x0030: df22 e23f .".?
22:20:15.427932 IP localhost.5810 > localhost.51542: P 1:16(15) ack 297 win
8192 <nop,nop,timestamp 3743605315 3743605311>
0x0000: 4500 0043 845e 4000 4006 b854 7f00 0001 [EMAIL
PROTECTED]@..T....
0x0010: 7f00 0001 16b2 c956 7a74 667d 7a4f 1790 .......Vztf}zO..
0x0020: 8018 2000 fe37 0000 0101 080a df22 e243 .....7.......".C
0x0030: df22 e23f 5200 0000 004b 0000 733b 387d .".?R....K..s;8}
0x0040: 0be0 5a ..Z
22:20:15.428027 IP localhost.51542 > localhost.5810: . ack 16 win 8192
<nop,nop,timestamp 3743605315 3743605315>
0x0000: 4500 0034 f44c 4000 4006 4875 7f00 0001 [EMAIL
PROTECTED]@.Hu....
0x0010: 7f00 0001 c956 16b2 7a4f 1790 7a74 668c .....V..zO..ztf.
0x0020: 8010 2000 8304 0000 0101 080a df22 e243 .............".C
0x0030: df22 e243 .".C
22:20:15.465021 IP localhost.51542 > localhost.5810: P 297:432(135) ack 16 win
8192 <nop,nop,timestamp 3743605352 3743605315>
0x0000: 4500 00bb f44e 4000 4006 47ec 7f00 0001 [EMAIL
PROTECTED]@.G.....
0x0010: 7f00 0001 c956 16b2 7a4f 1790 7a74 668c .....V..zO..ztf.
0x0020: 8018 2000 feaf 0000 0101 080a df22 e268 .............".h
0x0030: df22 e243 5173 6574 2064 6174 6573 7479 .".CQset.datesty
0x0040: 6c65 203d 2027 4953 4f27 3b20 7365 6c65 le.=.'ISO';.sele
0x0050: 6374 2076 6572 7369 6f6e 2829 2c20 6361 ct.version(),.ca
0x0060: 7365 2077 6865 6e20 7067 5f65 6e63 6f64 se.when.pg_encod
0x0070: 696e 675f 746f 5f63 6861 7228 3129 203d ing_to_char(1).=
0x0080: 2027 5351 4c5f 4153 4349 4927 2074 6865 .'SQL_ASCII'.the
0x0090: 6e20 2755 4e4b 4e4f 574e 2720 656c 7365 n.'UNKNOWN'.else
0x00a0: 2067 6574 6461 7461 6261 7365 656e 636f .getdatabaseenco
0x00b0: 6469 6e67 2829 2065 6e64 00 ding().end.
22:20:15.468293 IP localhost.5810 > localhost.51542: P 16:200(184) ack 432 win
8192 <nop,nop,timestamp 3743605355 3743605352>
0x0000: 4500 00ec 8460 4000 4006 b7a9 7f00 0001 [EMAIL
PROTECTED]@.......
0x0010: 7f00 0001 16b2 c956 7a74 668c 7a4f 1817 .......Vztf.zO..
0x0020: 8018 2000 fee0 0000 0101 080a df22 e26b .............".k
0x0030: df22 e268 4353 4554 0050 626c 616e 6b00 .".hCSET.Pblank.
0x0040: 5400 0276 6572 7369 6f6e 0000 0000 19ff T..version......
0x0050: ffff ffff ff67 6574 6461 7461 6261 7365 .....getdatabase
0x0060: 656e 636f 6469 6e67 0000 0000 1300 40ff [EMAIL PROTECTED]
0x0070: ffff ff44 0000 0000 6150 6f73 7467 7265 ...D....aPostgre
0x0080: 5351 4c20 382e 3164 6576 656c 206f 6e20 SQL.8.1devel.on.
0x0090: 6936 3836 2d70 632d 6c69 6e75 782d 676e i686-pc-linux-gn
0x00a0: 752c 2063 6f6d 7069 6c65 6420 6279 2047 u,.compiled.by.G
0x00b0: 4343 2067 6363 2028 4743 4329 2033 2e33 CC.gcc.(GCC).3.3
0x00c0: 2e35 2028 4465 6269 616e 2031 3a33 2e33 .5.(Debian.1:3.3
0x00d0: 2e35 2d31 3229 0000 000d 5351 4c5f 4153 .5-12)....SQL_AS
0x00e0: 4349 4943 5345 4c45 4354 005a CIICSELECT.Z
22:20:15.508136 IP localhost.51542 > localhost.5810: . ack 200 win 8192
<nop,nop,timestamp 3743605395 3743605355>
0x0000: 4500 0034 f450 4000 4006 4871 7f00 0001 [EMAIL
PROTECTED]@.Hq....
0x0010: 7f00 0001 c956 16b2 7a4f 1817 7a74 6744 .....V..zO..ztgD
0x0020: 8010 2000 814d 0000 0101 080a df22 e293 .....M......."..
0x0030: df22 e26b .".k
22:20:15.515896 IP localhost.51542 > localhost.5810: F 432:432(0) ack 200 win
8192 <nop,nop,timestamp 3743605403 3743605355>
0x0000: 4500 0034 f452 4000 4006 486f 7f00 0001 [EMAIL
PROTECTED]@.Ho....
0x0010: 7f00 0001 c956 16b2 7a4f 1817 7a74 6744 .....V..zO..ztgD
0x0020: 8011 2000 8144 0000 0101 080a df22 e29b .....D......."..
0x0030: df22 e26b .".k
22:20:15.517806 IP localhost.5810 > localhost.51542: F 200:200(0) ack 433 win
8192 <nop,nop,timestamp 3743605405 3743605403>
0x0000: 4500 0034 8462 4000 4006 b85f 7f00 0001 [EMAIL
PROTECTED]@.._....
0x0010: 7f00 0001 16b2 c956 7a74 6744 7a4f 1818 .......VztgDzO..
0x0020: 8011 2000 8111 0000 0101 080a df22 e29d ............."..
0x0030: df22 e29b ."..
22:20:15.517876 IP localhost.51542 > localhost.5810: . ack 201 win 8192
<nop,nop,timestamp 3743605405 3743605405>
0x0000: 4500 0034 f454 4000 4006 486d 7f00 0001 [EMAIL
PROTECTED]@.Hm....
0x0010: 7f00 0001 c956 16b2 7a4f 1818 7a74 6745 .....V..zO..ztgE
0x0020: 8010 2000 810f 0000 0101 080a df22 e29d ............."..
0x0030: df22 e29d ."..
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
