Ticket #1212 (new defect)

Opened 3 years ago

Timestamp w/tz and sqlite3 dataset

Reported by: aklaver Assigned to: somebody
Priority: major Milestone: 0.9.2
Component: ui Version: 0.9.1
Keywords: Cc:

Description

When pulling data from Postgres that has data type of timestamp with time zone there is a problem when it is put into sqlite3 :memory database for DataSet? usage. Attached is file with Postgres CREATE TABLE statement and data. Also attached is small Dabo app that demonstrates the problem. Lastly there is a file with commands executed from the Command shell and the traceback. As a note the Dabo form seems to have a problem where only every other timestamp value is displayed.

Attachments

ts_test.sql (0.6 kB) - added by aklaver on 03/11/09 13:51:48.
Postgres CREATE TABLE code
ts_test.2.sql (0.6 kB) - added by aklaver on 03/11/09 13:52:09.
Postgres CREATE TABLE code
ts_test_traceback.txt (1.0 kB) - added by aklaver on 03/11/09 13:52:46.
Traceback info
timestampTest.py (1.9 kB) - added by aklaver on 03/11/09 13:53:07.
Dabo app
tsTestCon.cnxml (0.5 kB) - added by aklaver on 03/11/09 13:53:26.
Connection info

Change History

03/11/09 13:51:48 changed by aklaver

  • attachment ts_test.sql added.

Postgres CREATE TABLE code

03/11/09 13:52:09 changed by aklaver

  • attachment ts_test.2.sql added.

Postgres CREATE TABLE code

03/11/09 13:52:46 changed by aklaver

  • attachment ts_test_traceback.txt added.

Traceback info

03/11/09 13:53:07 changed by aklaver

  • attachment timestampTest.py added.

Dabo app

03/11/09 13:53:26 changed by aklaver

  • attachment tsTestCon.cnxml added.

Connection info