I have trouble with my forms and save().
The issues are in getLastInsertID:
The 'tableName.split()' can't work because the method does not know anything
about tableName. Changed to
cursor.Table.split(".", 1)
The second issue is the sql is returning an error from postgres:
ERROR: syntax error at or near "as"
LINE 1: ...bstring(pg_get_expr(d.adbin, d.adrelid) for 128)) as curval ...
the above error is using the following sql:
SELECT curval(substring((SELECT substring(pg_get_expr(d.adbin, d.adrelid) for
128)) as curval
FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND
a.atthasdef)
FROM 'nextval[^'']*''([^'']*)')
FROM pg_attribute a
LEFT JOIN pg_class c ON c.oid = a.attrelid
LEFT JOIN pg_attrdef d ON d.adrelid = a.attrelid AND d.adnum = a.attnum AND
a.atthasdef
LEFT JOIN pg_namespace n ON c.relnamespace = n.oid",
"WHERE a.attname = 'pkid'", "AND (c.relname = 'arcont')",
" AND n.nspname = 'public'", "NOT a.attisdropped AND a.attnum > 0 AND
pg_get_expr(d.adbin, d.adrelid) LIKE 'nextval%'
I'm working on the problem just thought it be best to let you know.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message:
http://leafe.com/archives/byMID/[email protected]
