No error-checking on binary timestamp

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема No error-checking on binary timestamp
Дата
Msg-id 20040402201637.GQ7060@ns.snowman.net
обсуждение исходный текст
Список pgsql-bugs
Greetings,

  Based on some experimentation and reading through the code in:
  src/backend/utils/adl/timestamp.c ; it would appear that there's no
  error-checking when receiving a binary timestamp.  I wouldn't care if
  I had figured out the binary timestamp format on the first shot but
  apparently I didn't and this happened:

  atl=> select * from a5_lan;
  ERROR:  timestamp out of range

  No errors during the insert, but when I tried to select out of the
  table I inserted the data into that's what I got.  Pretty ugly.
  Please fix. :)

  I wouldn't mind some pointers on the proper way to convert from unix
  time to timestamp binary format either, btw.  I was attempting to do
  basically the same thing 'AbsoluteTimeUsecToTimestampTz', but
  apparently that's not right. :)

      Stephen

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

Предыдущее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1121: JDBC AbstractJdbc2ResultSet.deleteRow()
Следующее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1122: limit 1 doing a sequential scan