On Friday 24 August 2007 05:43, Ed Leafe wrote: > Then the getLastInsertID() method of dbPostgreSQL.py needs to be > modified, since it appears to be doing something very much like that, > but John says it is failing due to the open transaction.
Ed I was mistaken due to my mis-spelling of a sequence name during my debugging. FYI Your recent changes has had a good side effect of causing me to review the postgres interface. The problems as I see them: 1. All tables require primary keys. The select statement to retreive the fields names for the correct schema and table needs a primary key. As I recall I default to 'public' for the schema. 2. All tables require a sequence be created to support the primary keys. Else I have no way of retreiving the last PK. Of course this is a standard practice. Also the sequence has to be tied to the primary key. I dislike the select statement to getfields the most because I can see creating a table without needing a pkid. Last night Larry and I attempted to provide better select statements but failed. I will continue to review these select statements and will try to get help from the Postgres guys. Of course these requirements are normally used when building DB's and work well with Dabo programs (i.e. CnxEditor). -- 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/dabo-dev/[EMAIL PROTECTED]
