Re: ADO.NET ExecuteReader returns no rows

Поиск
Список
Период
Сортировка
От roman.motyka@gmail.com
Тема Re: ADO.NET ExecuteReader returns no rows
Дата
Msg-id 1143215096.965974.259800@i39g2000cwa.googlegroups.com
обсуждение исходный текст
Ответ на ADO.NET ExecuteReader returns no rows  (roman.motyka@gmail.com)
Список pgsql-general
I've compared Debug log between correct and wrong activity:
Good activity:
2006-03-24 16:30:36    2632    Debug    String written: select * from
getvideodata(2::int4, 1::int4, '2006-03-24 16:30:31.400000'::timestamp,
1::int4) AS (idvideodate timestamp, mediabinary bytea).
2006-03-24 16:30:36    2632    Debug    Entering
NpgsqlState.ProcessBackendResponses()
2006-03-24 16:30:36    2632    Debug    RowDescription message received from
server.
2006-03-24 16:30:36    2632    Debug    Entering
NpgsqlRowDescription.ReadFromStream_Ver_3()
2006-03-24 16:30:36    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:36    2632    Debug    String read: idvideodate.
2006-03-24 16:30:36    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:36    2632    Debug    String read: mediabinary.
2006-03-24 16:30:36    2632    Debug    DataRow message received from server.
2006-03-24 16:30:36    2632    Debug    Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
2006-03-24 16:30:36    2632    Debug    Entering
NpgsqlAsciiRow.ReadFromStream_Ver_3()
2006-03-24 16:30:36    2632    Debug    Entering
NpgsqlTypesHelper.ConvertBackendStringToSystemType()
2006-03-24 16:30:37    2632    Debug    Entering
NpgsqlTypesHelper.ConvertBackendStringToSystemType()
2006-03-24 16:30:38    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:38    2632    Debug    String read: SELECT.
2006-03-24 16:30:38    2632    Debug    CompletedResponse message from Server:
SELECT.
2006-03-24 16:30:38    2632    Debug    ReadyForQuery message received from
server.
2006-03-24 16:30:38    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:38    2632    Debug    String read: I.
...
Wrong activity:
2006-03-24 16:30:38    2632    Debug    String written: select * from
getvideodata(2::int4, 1::int4, '2006-03-24 16:30:35.400000'::timestamp,
1::int4) AS (idvideodate timestamp, mediabinary bytea).
2006-03-24 16:30:38    2632    Debug    Entering
NpgsqlState.ProcessBackendResponses()
2006-03-24 16:30:38    2632    Debug    RowDescription message received from
server.
2006-03-24 16:30:38    2632    Debug    Entering
NpgsqlRowDescription.ReadFromStream_Ver_3()
2006-03-24 16:30:38    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:38    2632    Debug    String read: idvideodate.
2006-03-24 16:30:38    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:38    2632    Debug    String read: mediabinary.
2006-03-24 16:30:38    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:38    2632    Debug    String read: SELECT.
2006-03-24 16:30:38    2632    Debug    CompletedResponse message from Server:
SELECT.
2006-03-24 16:30:38    2632    Debug    ReadyForQuery message received from
server.
2006-03-24 16:30:38    2632    Debug    Entering PGUtil.ReadString()
2006-03-24 16:30:38    2632    Debug    String read: I.
2006-03-24 16:30:38    2632    Debug    Entering NpgsqlState.ChangeState()
2006-03-24 16:30:38    2632    Debug    Entering
NpgsqlCommand.UpdateOutputParameters()
2006-03-24 16:30:38    2632    Debug    Get NpgsqlCommand.Connection
2006-03-24 16:30:48    2632    Debug    Entering NpgsqlDataReader.Read()
2006-03-24 16:30:48    2632    Debug    Entering NpgsqlDataReader.Dispose()
2006-03-24 16:30:48    2632    Debug    Entering NpgsqlConnection.Close()


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

Предыдущее
От: roman.motyka@gmail.com
Дата:
Сообщение: ADO.NET ExecuteReader returns no rows
Следующее
От: nik600
Дата:
Сообщение: inheridt tables from db