Re: BUG?: timestamp without TZ created as timestamp *with* - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: BUG?: timestamp without TZ created as timestamp *with*
Date
Msg-id 3D6EE7E3.3070906@mega-bucks.co.jp
Whole thread Raw
In response to BUG?: timestamp without TZ created as timestamp *with* TZ  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Responses Re: BUG?: timestamp without TZ created as timestamp *with*  (Alvaro Herrera <alvherre@atentus.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_group problem
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG?: timestamp without TZ created as timestamp *with*