[pilot-db-list] Error - plpython: TD["new"] has an incorrect number of keys.

[Scott C. <sco...@mi...>]

On Sunday 15 June 2003 12:50, Mike Meyer wrote:
> In <200...@mi...>, Scott Chapman 
<sco...@mi...> typed:
> > I'm considering a Linux application to synch data from a DB file into a
> > Postgresql database.
>
> I already wrote one - or at least a first pass at one. You may want to
> look at it <URL: http://www.mired.org/downloads/palm/ >.

Mike,
I got the dbsql.py mostly functioning.  I'm having a wierd error with the 
trigger to indicate when the record is modified.  Can you tell me what needs 
to be changed to make this fly?

pilot-db=# \d timelog_data
               Table "public.timelog_data"
     Column      |           Type            | Modifiers
-----------------+---------------------------+-----------
 task            | character varying(255)    |
 time            | time(0) without time zone |
 date            | date                      |
 palm_record_id  | integer                   |
 record_modified | boolean                   |
Triggers: timelog_trigger

pilot-db=# select * from timelog_data;
     task     |   time   |    date    | palm_record_id | record_modified
--------------+----------+------------+----------------+-----------------
 Network      | 11:14:00 | 2003-06-13 |        8933378 | f
 Tech Support | 14:16:00 | 2003-06-13 |        8933379 | f
 End Tasks    | 11:44:00 | 2003-06-17 |        8933377 | f
 End Tasks    | 14:16:00 | 2003-06-13 |        8933380 | f
(4 rows)

pilot-db=# update timelog_data set date = '2003-06-17' where palm_record_id = 
8933379;
ERROR:  plpython: TD["new"] has an incorrect number of keys.
pilot-db=#

Cordially,
Scott