Re: [GENERAL] ISO week dates

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [GENERAL] ISO week dates
Дата
Msg-id 20070216053904.GC29933@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: [GENERAL] ISO week dates  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: [GENERAL] ISO week dates  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches
Bruce Momjian escribió:
>
> Followup --- something weird is going on.  I am seeing _random_ failures
> of the regression tests here in that same place, and the build farm
> seems to fail in the same place, but with different row counts.

This failure is pretty interesting:

--- 724,730 ----
     date_part( 'isoyear', d1) AS isoyear, date_part( 'week', d1) AS week,
     date_part( 'dow', d1) AS dow
     FROM TIMESTAMP_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01';
! ERROR:  relation "timestamp_tbl" does not exist
  -- TO_CHAR()
  SELECT '' AS to_char_1, to_char(d1, 'DAY Day day DY Dy dy MONTH Month month RM MON Mon mon')
     FROM TIMESTAMPTZ_TBL;

http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=agouti&dt=2007-02-16%2005:15:01

How can the table fail to exist, and yet not report a problem when it
was created?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: WIP patch - INSERT-able log statements
Следующее
От: Alvaro Herrera
Дата:
Сообщение: further bootstrap cleanup