Frontend - Backend protocol change?

Поиск
Список
Период
Сортировка
От Bruce Badger
Тема Frontend - Backend protocol change?
Дата
Msg-id 3D1CE5F1.5090402@BadgerSE.com
обсуждение исходный текст
Ответы Re: Frontend - Backend protocol change?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-interfaces
I am testing the Smalltalk PostgreSQL drivers against PostgreSQL 7.2 and
I am seeing a change in the messages I get back from the backend for one
of my tests, even though the protocol version number is "0 2 0 0" in
both cases.

To run this test, I switch on message logging and connect to a 7.1
database (Redhat RPM version 7.1.3-2) and all is well.  The log for this
test is attached as trace-7.1.3-2.txt.

When I run the same test, from the same Smalltalk image, when connecting
to a 7.2 database (Redhat RPM version 7.2.1-5) the sequence of messages
is different, and my driver code flags an exception.  The log for this
test is attached as trace-7.2.1-5.txt.

The difference is that at 7.1 there is a CompletedResponseMessage
terminating each CursorResponseMessage.  At 7.2 there is only one
CompletedResponseMessage which terminates the second
CursorResponseMessage (so I got two CursorResponseMessage's, one
immediately after the other).

Here is the snippet from each log showing the query ('update
exdiTest21data set name = ''Harry'' where name = ''Larry'';') and the
responses from the back end.

My question is:  which is "right" the 7.1 behavior, or the 7.2 behavior?

*************************************
 From the 7.1 log:

June 28, 2002 5:30:48.718
 >>>>>   QueryMessage
'update exdiTest21data set name = ''Harry'' where name = ''Larry'';'

June 28, 2002 5:30:48.733
<<<<<   CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.736
<<<<<   CompletedResponseMessage
Command tag: INSERT 273804 1

June 28, 2002 5:30:48.740
<<<<<   CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.744
<<<<<   CompletedResponseMessage
Command tag: UPDATE 1

June 28, 2002 5:30:48.749
<<<<<   ReadyForQueryMessage

********************************************
 From the 7.2 log:

June 28, 2002 5:06:31.176
 >>>>>   QueryMessage
'update exdiTest21data set name = ''Harry'' where name = ''Larry'';'

June 28, 2002 5:06:31.304
<<<<<   CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.307
<<<<<   CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.311
<<<<<   CompletedResponseMessage
Command tag: UPDATE 1

[at this point my driver flags an error]


*********************************************
{28 Jun 2 5:30:48 am}     ExternalDatabaseConnection>>connect:
    Version: External Database Interface - Release 7.0
PostgreSQL EXDI layer 1.0 023

June 28, 2002 5:30:48.037
>>>>>    StartupPacket
Packet size: 296
Protocol version number: #[0 2 0 0]
Database name: 'test1'
User name: 'bbadger'
Additional arguments: ''
Debugging TTY: ''

June 28, 2002 5:30:48.068
<<<<<    AuthenticationOKMessage

June 28, 2002 5:30:48.079
<<<<<    BackendKeyDataMessage
Process ID: 10166
Secret Key: 317563785

June 28, 2002 5:30:48.083
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.088
>>>>>    QueryMessage
'drop table exdiTest21data'

June 28, 2002 5:30:48.508
<<<<<    CompletedResponseMessage
Command tag: DROP

June 28, 2002 5:30:48.511
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.517
>>>>>    QueryMessage
'drop table exdiTest21log'

June 28, 2002 5:30:48.543
<<<<<    CompletedResponseMessage
Command tag: DROP

June 28, 2002 5:30:48.546
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.550
>>>>>    QueryMessage
'drop rule exdiTest21data_update'

June 28, 2002 5:30:48.557
<<<<<    ErrorResponseMessage
Error message: ERROR:  Rule or view "exditest21data_update" not found

June 28, 2002 5:30:48.560
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.565
>>>>>    QueryMessage
'create table exdiTest21data (id int, name text, phone varchar(21))'

June 28, 2002 5:30:48.600
<<<<<    CompletedResponseMessage
Command tag: CREATE

June 28, 2002 5:30:48.604
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.608
>>>>>    QueryMessage
'create table exdiTest21log (oldName text, newName text)'

June 28, 2002 5:30:48.629
<<<<<    CompletedResponseMessage
Command tag: CREATE

June 28, 2002 5:30:48.632
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.636
>>>>>    QueryMessage
'    create rule exdiTest21data_update as on update to exdiTest21data    do insert into exdiTest21log (oldName, newName
)values (old.name, new.name);' 

June 28, 2002 5:30:48.648
<<<<<    CompletedResponseMessage
Command tag: CREATE

June 28, 2002 5:30:48.651
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.656
>>>>>    QueryMessage
'INSERT INTO exdiTest21data (id, name, phone) VALUES(1, ''Curly'', ''x47'')'

June 28, 2002 5:30:48.668
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.672
<<<<<    CompletedResponseMessage
Command tag: INSERT 273801 1

June 28, 2002 5:30:48.676
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.681
>>>>>    QueryMessage
'INSERT INTO exdiTest21data (id, name, phone) VALUES(2, ''Moe'', ''x29'')'

June 28, 2002 5:30:48.689
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.691
<<<<<    CompletedResponseMessage
Command tag: INSERT 273802 1

June 28, 2002 5:30:48.696
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.701
>>>>>    QueryMessage
'INSERT INTO exdiTest21data (id, name, phone) VALUES(3, ''Larry'', ''x83'')'

June 28, 2002 5:30:48.707
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.711
<<<<<    CompletedResponseMessage
Command tag: INSERT 273803 1

June 28, 2002 5:30:48.715
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.718
>>>>>    QueryMessage
'update exdiTest21data set name = ''Harry'' where name = ''Larry'';'

June 28, 2002 5:30:48.733
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.736
<<<<<    CompletedResponseMessage
Command tag: INSERT 273804 1

June 28, 2002 5:30:48.740
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.744
<<<<<    CompletedResponseMessage
Command tag: UPDATE 1

June 28, 2002 5:30:48.749
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.753
>>>>>    QueryMessage
'select oldname, newname from exdiTest21log where oldname = ''Larry'';'

June 28, 2002 5:30:48.760
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.763
<<<<<    RowDescriptionMessage
Number of fields: 2
Field description.  Name: oldname.  Object ID: 25.  Type size: 65535.  Type modifier: 4294967295
Field description.  Name: newname.  Object ID: 25.  Type size: 65535.  Type modifier: 4294967295

June 28, 2002 5:30:48.769
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [4C61727279].
Field #2: Bytes (hex): [4861727279].

June 28, 2002 5:30:48.775
<<<<<    CompletedResponseMessage
Command tag: SELECT

June 28, 2002 5:30:48.780
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:48.785
>>>>>    QueryMessage
'select oid, typname from pg_type'

June 28, 2002 5:30:48.795
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:30:48.798
<<<<<    RowDescriptionMessage
Number of fields: 2
Field description.  Name: oid.  Object ID: 26.  Type size: 4.  Type modifier: 4294967295
Field description.  Name: typname.  Object ID: 19.  Type size: 32.  Type modifier: 4294967295

June 28, 2002 5:30:48.804
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136].
Field #2: Bytes (hex): [626F6F6C].

June 28, 2002 5:30:48.809
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137].
Field #2: Bytes (hex): [6279746561].

June 28, 2002 5:30:48.814
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138].
Field #2: Bytes (hex): [63686172].

June 28, 2002 5:30:48.819
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3139].
Field #2: Bytes (hex): [6E616D65].

June 28, 2002 5:30:48.824
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3230].
Field #2: Bytes (hex): [696E7438].

June 28, 2002 5:30:48.829
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3231].
Field #2: Bytes (hex): [696E7432].

June 28, 2002 5:30:48.834
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3232].
Field #2: Bytes (hex): [696E7432766563746F72].

June 28, 2002 5:30:48.838
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3233].
Field #2: Bytes (hex): [696E7434].

June 28, 2002 5:30:48.843
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3234].
Field #2: Bytes (hex): [72656770726F63].

June 28, 2002 5:30:48.849
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3235].
Field #2: Bytes (hex): [74657874].

June 28, 2002 5:30:48.854
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3236].
Field #2: Bytes (hex): [6F6964].

June 28, 2002 5:30:48.859
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3237].
Field #2: Bytes (hex): [746964].

June 28, 2002 5:30:48.864
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3238].
Field #2: Bytes (hex): [786964].

June 28, 2002 5:30:48.869
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3239].
Field #2: Bytes (hex): [636964].

June 28, 2002 5:30:48.874
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3330].
Field #2: Bytes (hex): [6F6964766563746F72].

June 28, 2002 5:30:48.878
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3332].
Field #2: Bytes (hex): [534554].

June 28, 2002 5:30:48.893
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3731].
Field #2: Bytes (hex): [70675F74797065].

June 28, 2002 5:30:48.909
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3735].
Field #2: Bytes (hex): [70675F617474726962757465].

June 28, 2002 5:30:48.914
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3831].
Field #2: Bytes (hex): [70675F70726F63].

June 28, 2002 5:30:48.918
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3833].
Field #2: Bytes (hex): [70675F636C617373].

June 28, 2002 5:30:48.923
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3836].
Field #2: Bytes (hex): [70675F736861646F77].

June 28, 2002 5:30:48.928
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3837].
Field #2: Bytes (hex): [70675F67726F7570].

June 28, 2002 5:30:48.932
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3838].
Field #2: Bytes (hex): [70675F6461746162617365].

June 28, 2002 5:30:48.937
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3930].
Field #2: Bytes (hex): [70675F7661726961626C65].

June 28, 2002 5:30:48.942
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3939].
Field #2: Bytes (hex): [70675F6C6F67].

June 28, 2002 5:30:48.948
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [313039].
Field #2: Bytes (hex): [70675F61747472646566].

June 28, 2002 5:30:48.953
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [313130].
Field #2: Bytes (hex): [70675F72656C636865636B].

June 28, 2002 5:30:48.958
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [313131].
Field #2: Bytes (hex): [70675F74726967676572].

June 28, 2002 5:30:48.963
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323130].
Field #2: Bytes (hex): [736D6772].

June 28, 2002 5:30:48.968
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363030].
Field #2: Bytes (hex): [706F696E74].

June 28, 2002 5:30:48.972
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363031].
Field #2: Bytes (hex): [6C736567].

June 28, 2002 5:30:48.977
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363032].
Field #2: Bytes (hex): [70617468].

June 28, 2002 5:30:48.982
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363033].
Field #2: Bytes (hex): [626F78].

June 28, 2002 5:30:48.986
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363034].
Field #2: Bytes (hex): [706F6C79676F6E].

June 28, 2002 5:30:48.992
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363238].
Field #2: Bytes (hex): [6C696E65].

June 28, 2002 5:30:48.998
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363239].
Field #2: Bytes (hex): [5F6C696E65].

June 28, 2002 5:30:49.002
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373030].
Field #2: Bytes (hex): [666C6F617434].

June 28, 2002 5:30:49.008
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373031].
Field #2: Bytes (hex): [666C6F617438].

June 28, 2002 5:30:49.011
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373032].
Field #2: Bytes (hex): [61627374696D65].

June 28, 2002 5:30:49.017
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373033].
Field #2: Bytes (hex): [72656C74696D65].

June 28, 2002 5:30:49.022
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373034].
Field #2: Bytes (hex): [74696E74657276616C].

June 28, 2002 5:30:49.025
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373035].
Field #2: Bytes (hex): [756E6B6E6F776E].

June 28, 2002 5:30:49.031
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373138].
Field #2: Bytes (hex): [636972636C65].

June 28, 2002 5:30:49.036
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373139].
Field #2: Bytes (hex): [5F636972636C65].

June 28, 2002 5:30:49.041
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373930].
Field #2: Bytes (hex): [6D6F6E6579].

June 28, 2002 5:30:49.047
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [373931].
Field #2: Bytes (hex): [5F6D6F6E6579].

June 28, 2002 5:30:49.051
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [383239].
Field #2: Bytes (hex): [6D616361646472].

June 28, 2002 5:30:49.057
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [383639].
Field #2: Bytes (hex): [696E6574].

June 28, 2002 5:30:49.062
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363530].
Field #2: Bytes (hex): [63696472].

June 28, 2002 5:30:49.066
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303030].
Field #2: Bytes (hex): [5F626F6F6C].

June 28, 2002 5:30:49.071
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303031].
Field #2: Bytes (hex): [5F6279746561].

June 28, 2002 5:30:49.077
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303032].
Field #2: Bytes (hex): [5F63686172].

June 28, 2002 5:30:49.082
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303033].
Field #2: Bytes (hex): [5F6E616D65].

June 28, 2002 5:30:49.087
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303035].
Field #2: Bytes (hex): [5F696E7432].

June 28, 2002 5:30:49.091
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303036].
Field #2: Bytes (hex): [5F696E7432766563746F72].

June 28, 2002 5:30:49.096
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303037].
Field #2: Bytes (hex): [5F696E7434].

June 28, 2002 5:30:49.102
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303038].
Field #2: Bytes (hex): [5F72656770726F63].

June 28, 2002 5:30:49.105
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303039].
Field #2: Bytes (hex): [5F74657874].

June 28, 2002 5:30:49.110
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303238].
Field #2: Bytes (hex): [5F6F6964].

June 28, 2002 5:30:49.116
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303130].
Field #2: Bytes (hex): [5F746964].

June 28, 2002 5:30:49.121
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303131].
Field #2: Bytes (hex): [5F786964].

June 28, 2002 5:30:49.126
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303132].
Field #2: Bytes (hex): [5F636964].

June 28, 2002 5:30:49.131
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303133].
Field #2: Bytes (hex): [5F6F6964766563746F72].

June 28, 2002 5:30:49.136
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303134].
Field #2: Bytes (hex): [5F627063686172].

June 28, 2002 5:30:49.141
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303135].
Field #2: Bytes (hex): [5F76617263686172].

June 28, 2002 5:30:49.145
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303136].
Field #2: Bytes (hex): [5F696E7438].

June 28, 2002 5:30:49.150
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303137].
Field #2: Bytes (hex): [5F706F696E74].

June 28, 2002 5:30:49.155
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303138].
Field #2: Bytes (hex): [5F6C736567].

June 28, 2002 5:30:49.161
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303139].
Field #2: Bytes (hex): [5F70617468].

June 28, 2002 5:30:49.166
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303230].
Field #2: Bytes (hex): [5F626F78].

June 28, 2002 5:30:49.171
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303231].
Field #2: Bytes (hex): [5F666C6F617434].

June 28, 2002 5:30:49.176
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303232].
Field #2: Bytes (hex): [5F666C6F617438].

June 28, 2002 5:30:49.181
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303233].
Field #2: Bytes (hex): [5F61627374696D65].

June 28, 2002 5:30:49.185
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303234].
Field #2: Bytes (hex): [5F72656C74696D65].

June 28, 2002 5:30:49.190
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303235].
Field #2: Bytes (hex): [5F74696E74657276616C].

June 28, 2002 5:30:49.195
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303237].
Field #2: Bytes (hex): [5F706F6C79676F6E].

June 28, 2002 5:30:49.201
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303333].
Field #2: Bytes (hex): [61636C6974656D].

June 28, 2002 5:30:49.206
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303334].
Field #2: Bytes (hex): [5F61636C6974656D].

June 28, 2002 5:30:49.211
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303430].
Field #2: Bytes (hex): [5F6D616361646472].

June 28, 2002 5:30:49.216
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303431].
Field #2: Bytes (hex): [5F696E6574].

June 28, 2002 5:30:49.221
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [363531].
Field #2: Bytes (hex): [5F63696472].

June 28, 2002 5:30:49.225
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303432].
Field #2: Bytes (hex): [627063686172].

June 28, 2002 5:30:49.230
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303433].
Field #2: Bytes (hex): [76617263686172].

June 28, 2002 5:30:49.235
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303832].
Field #2: Bytes (hex): [64617465].

June 28, 2002 5:30:49.239
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31303833].
Field #2: Bytes (hex): [74696D65].

June 28, 2002 5:30:49.245
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31313832].
Field #2: Bytes (hex): [5F64617465].

June 28, 2002 5:30:49.250
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31313833].
Field #2: Bytes (hex): [5F74696D65].

June 28, 2002 5:30:49.255
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31313834].
Field #2: Bytes (hex): [74696D657374616D70].

June 28, 2002 5:30:49.260
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31313835].
Field #2: Bytes (hex): [5F74696D657374616D70].

June 28, 2002 5:30:49.265
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31313836].
Field #2: Bytes (hex): [696E74657276616C].

June 28, 2002 5:30:49.270
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31313837].
Field #2: Bytes (hex): [5F696E74657276616C].

June 28, 2002 5:30:49.275
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31323331].
Field #2: Bytes (hex): [5F6E756D65726963].

June 28, 2002 5:30:49.278
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31323636].
Field #2: Bytes (hex): [74696D65747A].

June 28, 2002 5:30:49.284
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31323730].
Field #2: Bytes (hex): [5F74696D65747A].

June 28, 2002 5:30:49.289
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31353630].
Field #2: Bytes (hex): [626974].

June 28, 2002 5:30:49.294
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31353631].
Field #2: Bytes (hex): [5F626974].

June 28, 2002 5:30:49.299
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31353632].
Field #2: Bytes (hex): [766172626974].

June 28, 2002 5:30:49.304
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31353633].
Field #2: Bytes (hex): [5F766172626974].

June 28, 2002 5:30:49.309
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [31373030].
Field #2: Bytes (hex): [6E756D65726963].

June 28, 2002 5:30:49.314
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136353638].
Field #2: Bytes (hex): [70675F696E686572697473].

June 28, 2002 5:30:49.318
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136353830].
Field #2: Bytes (hex): [70675F696E646578].

June 28, 2002 5:30:49.324
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136363031].
Field #2: Bytes (hex): [70675F737461746973746963].

June 28, 2002 5:30:49.331
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136363138].
Field #2: Bytes (hex): [70675F6F70657261746F72].

June 28, 2002 5:30:49.336
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136363433].
Field #2: Bytes (hex): [70675F6F70636C617373].

June 28, 2002 5:30:49.341
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136363534].
Field #2: Bytes (hex): [70675F616D].

June 28, 2002 5:30:49.345
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136363836].
Field #2: Bytes (hex): [70675F616D6F70].

June 28, 2002 5:30:49.350
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136383638].
Field #2: Bytes (hex): [70675F616D70726F63].

June 28, 2002 5:30:49.355
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136393335].
Field #2: Bytes (hex): [70675F6C616E6775616765].

June 28, 2002 5:30:49.359
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136393439].
Field #2: Bytes (hex): [70675F6C617267656F626A656374].

June 28, 2002 5:30:49.366
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3136393631].
Field #2: Bytes (hex): [70675F616767726567617465].

June 28, 2002 5:30:49.371
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137303334].
Field #2: Bytes (hex): [70675F69706C].

June 28, 2002 5:30:49.376
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137303436].
Field #2: Bytes (hex): [70675F696E686572697470726F63].

June 28, 2002 5:30:49.381
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137303539].
Field #2: Bytes (hex): [70675F72657772697465].

June 28, 2002 5:30:49.385
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137303735].
Field #2: Bytes (hex): [70675F6C697374656E6572].

June 28, 2002 5:30:49.390
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137303837].
Field #2: Bytes (hex): [70675F6465736372697074696F6E].

June 28, 2002 5:30:49.413
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323032].
Field #2: Bytes (hex): [70675F746F6173745F31323135].

June 28, 2002 5:30:49.418
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323137].
Field #2: Bytes (hex): [70675F746F6173745F3137303836].

June 28, 2002 5:30:49.424
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323332].
Field #2: Bytes (hex): [70675F746F6173745F31323535].

June 28, 2002 5:30:49.430
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323437].
Field #2: Bytes (hex): [70675F746F6173745F31323136].

June 28, 2002 5:30:49.435
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323632].
Field #2: Bytes (hex): [70675F746F6173745F3137303538].

June 28, 2002 5:30:49.438
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323737].
Field #2: Bytes (hex): [70675F746F6173745F3136363030].

June 28, 2002 5:30:49.444
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137323932].
Field #2: Bytes (hex): [70675F75736572].

June 28, 2002 5:30:49.449
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137333130].
Field #2: Bytes (hex): [70675F72756C6573].

June 28, 2002 5:30:49.454
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137333233].
Field #2: Bytes (hex): [70675F7669657773].

June 28, 2002 5:30:49.459
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137333336].
Field #2: Bytes (hex): [70675F7461626C6573].

June 28, 2002 5:30:49.464
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3137333531].
Field #2: Bytes (hex): [70675F696E6465786573].

June 28, 2002 5:30:49.470
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138373233].
Field #2: Bytes (hex): [7067615F71756572696573].

June 28, 2002 5:30:49.475
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138373339].
Field #2: Bytes (hex): [70675F746F6173745F3138373232].

June 28, 2002 5:30:49.478
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138373534].
Field #2: Bytes (hex): [7067615F666F726D73].

June 28, 2002 5:30:49.484
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138373635].
Field #2: Bytes (hex): [70675F746F6173745F3138373533].

June 28, 2002 5:30:49.489
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138373830].
Field #2: Bytes (hex): [7067615F73637269707473].

June 28, 2002 5:30:49.494
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138373931].
Field #2: Bytes (hex): [70675F746F6173745F3138373739].

June 28, 2002 5:30:49.499
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138383036].
Field #2: Bytes (hex): [7067615F7265706F727473].

June 28, 2002 5:30:49.504
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138383230].
Field #2: Bytes (hex): [70675F746F6173745F3138383035].

June 28, 2002 5:30:49.510
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138383335].
Field #2: Bytes (hex): [7067615F736368656D61].

June 28, 2002 5:30:49.515
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [3138383437].
Field #2: Bytes (hex): [70675F746F6173745F3138383334].

June 28, 2002 5:30:49.520
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639333035].
Field #2: Bytes (hex): [657864697465737432326C6F67].

June 28, 2002 5:30:49.525
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639333137].
Field #2: Bytes (hex): [70675F746F6173745F323639333034].

June 28, 2002 5:30:49.530
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [313235383137].
Field #2: Bytes (hex): [706172746E657273].

June 28, 2002 5:30:49.536
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [313235383331].
Field #2: Bytes (hex): [7067615F6C61796F7574].

June 28, 2002 5:30:49.541
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [313235383434].
Field #2: Bytes (hex): [70675F746F6173745F313235383330].

June 28, 2002 5:30:49.545
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638383235].
Field #2: Bytes (hex): [65786469746573743037].

June 28, 2002 5:30:49.551
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638383538].
Field #2: Bytes (hex): [70675F746F6173745F323638383234].

June 28, 2002 5:30:49.556
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638393338].
Field #2: Bytes (hex): [65786469746573743130].

June 28, 2002 5:30:49.561
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638393439].
Field #2: Bytes (hex): [70675F746F6173745F323638393337].

June 28, 2002 5:30:49.567
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638393638].
Field #2: Bytes (hex): [657864697465737431315F6964656E746974795F736571].

June 28, 2002 5:30:49.571
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638393837].
Field #2: Bytes (hex): [65786469746573743131].

June 28, 2002 5:30:49.577
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323638393939].
Field #2: Bytes (hex): [70675F746F6173745F323638393836].

June 28, 2002 5:30:49.582
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639303231].
Field #2: Bytes (hex): [657864697465737431325F6964656E746974795F736571].

June 28, 2002 5:30:49.586
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639303430].
Field #2: Bytes (hex): [65786469746573743132].

June 28, 2002 5:30:49.592
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639303532].
Field #2: Bytes (hex): [70675F746F6173745F323639303339].

June 28, 2002 5:30:49.598
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639303734].
Field #2: Bytes (hex): [657864697465737431335F6964656E746974795F736571].

June 28, 2002 5:30:49.603
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639303933].
Field #2: Bytes (hex): [65786469746573743133].

June 28, 2002 5:30:49.608
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639313035].
Field #2: Bytes (hex): [70675F746F6173745F323639303932].

June 28, 2002 5:30:49.612
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639313431].
Field #2: Bytes (hex): [7461736B].

June 28, 2002 5:30:49.617
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639313531].
Field #2: Bytes (hex): [61737369676E6565].

June 28, 2002 5:30:49.622
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639313631].
Field #2: Bytes (hex): [61737369676E6D656E74].

June 28, 2002 5:30:49.627
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639323738].
Field #2: Bytes (hex): [6578646974657374323264617461].

June 28, 2002 5:30:49.635
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323639323930].
Field #2: Bytes (hex): [70675F746F6173745F323639323737].

June 28, 2002 5:30:49.638
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323733373438].
Field #2: Bytes (hex): [6578646974657374323164617461].

June 28, 2002 5:30:49.644
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323733373630].
Field #2: Bytes (hex): [70675F746F6173745F323733373437].

June 28, 2002 5:30:49.649
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323733373735].
Field #2: Bytes (hex): [657864697465737432316C6F67].

June 28, 2002 5:30:49.654
<<<<<    AsciiRowMessage
Field #1: Bytes (hex): [323733373836].
Field #2: Bytes (hex): [70675F746F6173745F323733373734].

June 28, 2002 5:30:49.659
<<<<<    CompletedResponseMessage
Command tag: SELECT

June 28, 2002 5:30:49.664
<<<<<    ReadyForQueryMessage

June 28, 2002 5:30:49.672
>>>>>    TerminateMessage
{28 Jun 2 5:06:30 am}     ExternalDatabaseConnection>>connect:
    Version: External Database Interface - Release 7.0
PostgreSQL EXDI layer 1.0 023

June 28, 2002 5:06:30.261
>>>>>    StartupPacket
Packet size: 296
Protocol version number: #[0 2 0 0]
Database name: 'test1'
User name: 'bbadger'
Additional arguments: ''
Debugging TTY: ''

June 28, 2002 5:06:30.289
<<<<<    AuthenticationOKMessage

June 28, 2002 5:06:30.504
<<<<<    BackendKeyDataMessage
Process ID: 5991
Secret Key: 1282360237

June 28, 2002 5:06:30.507
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:30.512
>>>>>    QueryMessage
'drop table exdiTest21data'

June 28, 2002 5:06:30.756
<<<<<    CompletedResponseMessage
Command tag: DROP

June 28, 2002 5:06:30.759
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:30.763
>>>>>    QueryMessage
'drop table exdiTest21log'

June 28, 2002 5:06:30.778
<<<<<    CompletedResponseMessage
Command tag: DROP

June 28, 2002 5:06:30.781
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:30.785
>>>>>    QueryMessage
'drop rule exdiTest21data_update'

June 28, 2002 5:06:30.806
<<<<<    ErrorResponseMessage
Error message: ERROR:  Rule or view "exditest21data_update" not found

June 28, 2002 5:06:30.809
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:30.814
>>>>>    QueryMessage
'create table exdiTest21data (id int, name text, phone varchar(21))'

June 28, 2002 5:06:30.970
<<<<<    CompletedResponseMessage
Command tag: CREATE

June 28, 2002 5:06:30.973
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:30.977
>>>>>    QueryMessage
'create table exdiTest21log (oldName text, newName text)'

June 28, 2002 5:06:30.995
<<<<<    CompletedResponseMessage
Command tag: CREATE

June 28, 2002 5:06:30.998
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:31.002
>>>>>    QueryMessage
'    create rule exdiTest21data_update as on update to exdiTest21data    do insert into exdiTest21log (oldName, newName
)values (old.name, new.name);' 

June 28, 2002 5:06:31.029
<<<<<    CompletedResponseMessage
Command tag: CREATE

June 28, 2002 5:06:31.032
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:31.035
>>>>>    QueryMessage
'INSERT INTO exdiTest21data (id, name, phone) VALUES(1, ''Curly'', ''x47'')'

June 28, 2002 5:06:31.129
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.132
<<<<<    CompletedResponseMessage
Command tag: INSERT 16959 1

June 28, 2002 5:06:31.136
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:31.140
>>>>>    QueryMessage
'INSERT INTO exdiTest21data (id, name, phone) VALUES(2, ''Moe'', ''x29'')'

June 28, 2002 5:06:31.148
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.151
<<<<<    CompletedResponseMessage
Command tag: INSERT 16960 1

June 28, 2002 5:06:31.155
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:31.159
>>>>>    QueryMessage
'INSERT INTO exdiTest21data (id, name, phone) VALUES(3, ''Larry'', ''x83'')'

June 28, 2002 5:06:31.166
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.169
<<<<<    CompletedResponseMessage
Command tag: INSERT 16961 1

June 28, 2002 5:06:31.172
<<<<<    ReadyForQueryMessage

June 28, 2002 5:06:31.176
>>>>>    QueryMessage
'update exdiTest21data set name = ''Harry'' where name = ''Larry'';'

June 28, 2002 5:06:31.304
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.307
<<<<<    CursorResponseMessage
Cursor name: blank

June 28, 2002 5:06:31.311
<<<<<    CompletedResponseMessage
Command tag: UPDATE 1

June 28, 2002 5:08:18.488
>>>>>    TerminateMessage

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: jtv
Дата:
Сообщение: Re: pqxx::Connection("dbname=name");
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Frontend - Backend protocol change?