PostgreSQL 7.3.4 ��ȯ�ԥ��
Prev	Chapter 4. �ե��ȥ��/�Хå��ɥץ��ȥ��	Next

4.4. ��å��η��

��ǤϤ��줾��Υ�å��η��ˤĤ��Ƶ��ܤ��ޤ��줾��ϥե��ȥ��ɡ�F�ˡ�postmaster �ȥХå�� B�� 뤤��F & B�ˤ��Ф��ޤ��

AsciiRow (B)

Byte1('D')

��å�� ASCII�ǡ��ԤǤ��뤳�Ȥ򼨤��ޤ��Ԥ��RowDescription��å��ǹԤ��Υե��ɿ��Ȥ��Υǡ��ޤ��ˡ�

Byten

�Ԥγƥե��ɤ�1�ӥåȤ��б��ӥåȥޥåפǤ��1 �ե��ɤ��1�Х��ȤΥӥå�7��MSB�ˤ��б��2�ե��ɤ��1�Х��ȤΥӥå�6��8�ե��ɤ��1�Х��ȤΥӥå�0��LSB�ˡ��9�ե��ɤ��2�Х��ȤΥӥå�7�Ȥ��ä��б��ޤ��б��ե��ɤ��ͤ�NULL�Ǥʤ��¤ꤽ�줾��ΥӥåȤ�Ω�Ƥ��ޤ��⤷�ե��ɿ��8��ܿ��Ǥʤ��ˤϡ��ӥåȥޥåפˤ��Ǹ�ΥХ��Ȥ�;��פȤʤ�ޤ��

�ͤ�NULL�Ǥʤ��줾��Υե��ɤ��Ф��ưʲ��ޤ��

Int32: ��Υ��ޤ᤿�ե��ɤ��ͤ��礭��ꤷ�ޤ��
Byten: ASCIIʸ��ǤΥե��ɤ��ͤ��Τ�Τλ��Ǥ�� n�Ͼ嵭�Υ��4��ΤǤ�� ե��ɥǡ��κǸ�ˤϥ��ΥХ��Ȥ��դ��Ƥ��ޤ�� ɬ�פʤ�ե��ȥ��ɤ��ղä��ʤ��Ф��ޤ��

AuthenticationOk (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(0): ǧ�ڤ��Ȥ򼨤��ޤ��

AuthenticationKerberosV4 (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(1): Kerberos V4��ǧ�ڤ�ɬ�פʤ��Ȥ��ꤷ�ޤ��

AuthenticationKerberosV5 (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(2): Kerberos V5��ǧ�ڤ�ɬ�פʤ��Ȥ��ꤷ�ޤ��

AuthenticationCleartextPassword (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(3): ʿʸ�ѥ���ɤ�ɬ�פǤ��뤳�Ȥ��ꤷ�ޤ��

AuthenticationCryptPassword (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(4): crypt() �ˤ��Ź沽�ѥ���ɤ�ɬ�פǤ��뤳�Ȥ��ꤷ�ޤ��
Byte2: �ѥ���ɤ�Ź沽��Ȥ��˻��Ѥ��륽��ȤǤ��

AuthenticationMD5Password (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(5): MD5 �Ź沽�ѥ���ɤ�ɬ�פǤ��뤳�Ȥ��ꤷ�ޤ��
Byte4: �ѥ���ɤ�Ź沽��Ȥ��˻��Ѥ��륽��ȤǤ��

AuthenticationSCMCredential (B)

Byte1('R'): ��å��ǧ��׵�Ǥ��뤳�Ȥ򼨤��ޤ��
Int32(6): SCM ��ʾ��å��ɬ�פǤ��뤳�Ȥ��ꤷ�ޤ��

BackendKeyData (B)

Byte1('K'): ��å��ä��θ��ǡ��Ǥ��뤳�Ȥ򼨤��ޤ��ե��ȥ��ɤϸ��CancelRequest��å��Ф��ΤǤ��Ф��ͤ��¸��Ƥ��ʤ��Фʤ�ޤ��
Int32: ��ΥХå��ɤΥץ��ID�Ǥ��
Int32: ��ΥХå��ɤ��̩��Ǥ��

BinaryRow (B)

Byte1('B')

��å��Х��ʥ�ǡ��ԤǤ��뤳�Ȥ򼨤��ޤ��Ԥ�� RowDescription ��å��ǹԤ��Υե��ɿ��Ȥ��Υǡ��ޤ��ˡ�

Byten

�ͤ�NULL�Ǥʤ��줾��Υե��ɤ��Ф��ưʲ��ޤ��

Int32: ��Υ��ޤ�ʤ��ե��ɤ��ͤ��礭��ꤷ�ޤ��
Byten: �Х��ʥ��ǤΥե��ɤ��Τ�Τ��ͤ��ꤷ�ޤ�� n�Ͼ嵭�Υ��Ǥ��

CancelRequest (F)

Int32(16): �Х��ȿ��ˤ��ѥ��åȤΥ��Ǥ��
Int32(80877102): ��ä��׵�Υ��ɡ� �Ǿ��16�ӥåȤ� 1234 ��ǲ��16�ӥåȤ�5678 ��ޤ�褦��ͤ��Ф�ޤ��ʺ��򤱤뤿�ᡢ��Υ��ɤ�¾�Υץ��ȥ��С��Ȥ�Ʊ��Ǥ��ޤ��ˡ�
Int32: ��Ū�Ȥ��Хå��ɤΥץ��ID�Ǥ��
Int32: ��Ū�Ȥ��Хå��ɤ��̩��Ǥ��

CompletedResponse (B)

Byte1('C')

��å��λ��Ǥ��뤳�Ȥ򼨤��ޤ��

String

��ޥ�ɥ�� ̾�ɤ�SQL̿�᤬��λ��򼨤�1ñ��Ǥ��

INSERT ��ޥ�ɤξ�硢��Υ�� INSERT oid rows �Ǥ�� rows ��줿�Ԥο��򼨤��ޤ�� ޤ��oid �ϡ�rows �� 1 �ξ�硢��줿�ԤΥ��֥�� ID �򼨤��ޤ�� ʤ��С�oid �� 0 �Ȥʤ�ޤ��

DELETE ��ޥ�ɤξ�硢��Υ�� DELETE rows �Ǥ�� rows �Ϻ��줿�Ԥο��Ǥ��

UPDATE ��ޥ�ɤξ�硢��Υ�� UPDATE rows �Ǥ�� rows �Ϲ��줿�Ԥο��Ǥ��

CopyDataRows (B & F)

Ϣ³��ԥǡ��ǡ��ƹԤ�Byte1('\n')�ǽ��ޤ��٤ƤΥǡ��ΰ��ֺǸ�ˤ�Byte1('\\')��Byte1('.')��Byte1('\n')�Ȥ��ʸ��¤Ӥ��դ��ޤ��

CopyInResponse (B)

Byte1('G'): ��å��֥��ԡ��γ��ϡפǤ��뤳�Ȥ򼨤��ޤ�� ե��ȥ��ɤϤ��ǡ�CopyDataRows��å��ʤ��Фʤ�ޤ��

CopyOutResponse (B)

Byte1('H'): ��å��֥��ԡ��Ȥγ��ϡפǤ��뤳�Ȥ򼨤��ޤ�� Υ��ޥ�ɤˤϡ��CopyDataRows��å��³��ޤ��

CursorResponse (B)

Byte1('P'): ��å��Ǥ��뤳�Ȥ��̤��ޤ��
String: ��̾�Ρ��̾��Ū�˻��ꤷ�ʤ��ä��硢�� "blank"�Ȥ��ʸ��ˤʤ�ޤ��

EmptyQueryResponse (B)

Byte1('I'): ��å��䤤��碌ʸ��β��Ǥ��뤳�Ȥ򼨤��ޤ��
String(""): ̤��ѡ�

ErrorResponse (B)

Byte1('E'): ��å��顼��å��Ǥ��뤳�Ȥ��̤��ޤ��
String: ��顼��å��Τ�ΤǤ��

FunctionCall (F)

Byte1('F')

��å��ؿ��ƤӽФ��Ǥ��뤳�Ȥ򼨤��ޤ��

String("")

̤��ѡ�

Int32

�ƤӽФ��ؿ��Υ��֥��ID��ꤷ�ޤ��

Int32

�ؿ��Ϥ��ο��ꤷ�ޤ��

��줾��ΰ��Ф��ưʲ��Τ�Τ��ޤ��

Int32: ��Υ��ͤΥ��λ��ꡣ
Byten: �Х��ʥ��ǤΥե��ɤ��Τ�Τ��ͤ��ꤷ�ޤ�� n�Ͼ嵭�Υ��Ǥ��

FunctionResultResponse (B)

Byte1('V'): ��å��ؿ��ƤӽФ��η�̤Ǥ��뤳�Ȥ򼨤��ޤ��
Byte1('G'): ��Ǥʤ��̤��֤��줿��Ȥ��ꤷ�ޤ��
Int32: ��Υ��̤��ͤΥ��ꤷ�ޤ��
Byten: �Х��ʥ��Ƿ�̤��ͤ��Τ�Τ��ꤷ�ޤ�� n�Ͼ嵭�Υ��Ǥ��
Byte1('0'): ̤��ѡʸ�̩�ˤϡ�FunctionResultResponse �� FunctionVoidResponse ��Ʊ��Τ�ΤǤ��å��Ф��Ƥ��Ĥ��ʬ��ޤ��ˡ�

FunctionVoidResponse (B)

Byte1('V'): ��å��ؿ��ƤӽФ��η�̤Ǥ��뤳�Ȥ򼨤��ޤ��
Byte1('0'): ��η�̤��֤��줿��Ȥ��ꤷ�ޤ��

NoticeResponse (B)

Byte1('N'): ��å��ΤǤ��뤳�Ȥ��̤��ޤ��
String: ��Υ�å��Τ�ΤǤ��

NotificationResponse (B)

Byte1('A'): ��å��Τ˴ؤ��Ǥ��뤳�Ȥ��̤��ޤ��
Int32: ��Τ�Ԥä��Хå��ɥץ��Υץ��ID��
String: ��Τ�ȯ��̾�ΤǤ��

PasswordPacket (F)

Int32: �Х��ȿ��ˤ��ѥ��åȤΥ��Ǥ��
String: (ɬ�פ˱��ưŹ沽)�ѥ���ɤǤ��

Query (F)

Byte1('Q'): ��å��䤤��碌�Ǥ��뤳�Ȥ򼨤��ޤ��
String: �䤤��碌ʸ��󤽤Τ�Ρ�

ReadyForQuery (B)

Byte1('Z'): ��å��η��򼨤��ޤ��Хå��ɤ��䤤��碌��ReadyForQuery��ޤ��

RowDescription (B)

Byte1('T')

��å��Ԥβ��Ǥ��뤳�Ȥ��̤��ޤ��

Int16

�ԤΥե��ɿ��0�ξ��⤢��ˤ��ꤷ�ޤ��

��줾��Υե��ɤ��Ф��ʲ��Τ�Τ��ޤ��

String: �ե��̾��ꤷ�ޤ��
Int32: �ե��ɤη��Υ��֥��ID��ꤷ�ޤ��
Int16: ��Υ��ꤷ�ޤ��
Int32: ��ν��Ҥ��ꤷ�ޤ��

SSLRequest (F)

Int32(8): �Х��ȿ��ˤ��ѥ��åȤΥ��Ǥ��
Int32(80877103): SSL�׵ᥳ��ɡ� �Ǿ��16�ӥåȤ� 1234 ��ǲ��16�ӥåȤ�5679 ��ޤ�褦��ͤ��Ф�ޤ��ʺ��򤱤뤿�ᡢ��Υ��ɤ�¾�Υץ��ȥ��С��Ȥ�Ʊ��Ǥ��ޤ��ˡ�

StartupPacket (F)

Int32(296): �Х��ȿ��ˤ��ѥ��åȤΥ��Ǥ��
Int32: �ץ��ȥ��ΥС��ֹ档�Ǿ��16�ӥåȤϥ᥸�㡼�С��ֹ�Ǥ��ǲ��16�ӥåȤϥޥ��ʡ��С��ֹ��ɽ��ޤ��
LimString64: �ǡ��١��̾�� ξ��ϥ桼��̾��ǥե��Ȥˤʤ�ޤ�
LimString32: �桼��̾
LimString64: ��Фˤ��Хå��ɻҥץ��Ϥ��롢Ǥ�դ��ɲäΥ��ޥ�ɥ饤��
LimString64: ̤��ѡ�
LimString64: �Хå��ɤ��å��ΥǥХå��˻��Ѥ��Ǥ�դ�tty�Ǥ�(��ߡ��Υե��ɤϥ��ݡ��Ȥ��Ƥ��餺��̵�뤵��ޤ�)��

Terminate (F)

Byte1('X'): ��å��λ�Ǥ��뤳�Ȥ��̤��ޤ��

Prev	Home	Next
��å��Υǡ��	Up	gcc �ǥե��Ⱥ�Ŭ��

4.4. ��å������η���

4.4. ��å��η��