Read-only records with timestamp

From: Popovics Attila <apopovics(at)interm(dot)gtk(dot)gau(dot)hu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Read-only records with timestamp
Date: 2002-04-29 11:00:44
Message-ID: Pine.LNX.4.44.0204291215480.31500-100000@interm.gtk.gau.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi
I have some tables with timestamp field
(timestamp with time zone | default now()).
It worked well in 7.1.3, but in 7.2.1 the newly inserted records are
read only through the odbc (MS Access, pgAdmin 1.2.0).
I analized the log files and I found that:
on update or on delete the client sends string like this
'update .... set .... where ... and "idoppont" = '2002-04-26 14:05:17.44'::timestamp'

but

in plsql in same record
the value of the field is 2002-04-26 14:05:17.440044+02

end finally

select '2002-04-26 14:05:17.44'::timestamp;
timestamptz
---------------------------
2002-04-26 14:05:17.44+02

What I have to do to eliminate this problem?

Thanks
Attila Popovics

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Darley 2002-04-29 13:57:43 Re: Read-only records with timestamp
Previous Message Hiroshi Inoue 2002-04-29 04:28:50 Re: ODBC3, VB, cursortype, bug and transactions