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*  (Alvaro Herrera <alvherre@atentus.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_group problem
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG?: timestamp without TZ created as timestamp *with*