logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: BUG?: timestamp without TZ created as timestamp *with*: msg#01192

Subject: Re: BUG?: timestamp without TZ created as timestamp *with*
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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly




Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>