Re: BUG?: timestamp without TZ created as timestamp *with*

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Re: BUG?: timestamp without TZ created as timestamp *with*
Дата
Msg-id 3D6EE7E3.3070906@mega-bucks.co.jp
обсуждение исходный текст
Ответ на BUG?: timestamp without TZ created as timestamp *with* TZ  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Ответы Re: BUG?: timestamp without TZ created as timestamp *with*
Список pgsql-general
Tom Lane wrote:
 >
 >There's also a nasty little bug in the 7.2 system catalogs:

Is this error message related to that bug? The error make no sense, it's
complaining that the DB is expecting one data type (timstamp with TZ),
receiving it, but not happy with it ...

Warning: pg_exec() query failed: ERROR: column "last_login" is of type
'timestamp with time zone[]' but expression is of type 'timestamp with
time zone' You will need to rewrite or cast the expression in
/www/htdocs/jc/db_functions/db_functions.inc on line 509
CONNECTION: could not execute query (insert into members(first_name,
last_name, first_name_kana, last_name_kana, primary_email, pw_hash,
membership_type, sex, dob, payment_type, last_login)
values('2','1','1','2','','12tir.zIbWQ3c','','f','1920-10-29','',now()))

Jc


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