#1189: Some improvements of the Posgres support (schema names, composite primary
keys)
----------------------+-----------------------------------------------------
Reporter: cito | Owner: somebody
Type: defect | Status: new
Priority: minor | Milestone: 0.8.3
Component: ui | Version: 0.8.4
Keywords: postgres |
----------------------+-----------------------------------------------------
This patch improves Postgres support in dabo.
Currently, datasources must always contain a schema name when a Postgres
database is used. This makes is impossible to create apps that can run in
different schemas depending on the current search path. Also, apps written
for MySQL or SQLite need adaption if you switch to Postgres. The patch now
allows unqualified schema names as well.
Another problem is that the `getFields()` method uses an additional query
to request the primary key fields, but then evaluates only the first
field, though a table can have a composite primary key consisting of more
than one field. The patched method uses only one, simplified query, and
recognizes all primary key components.
The two queries in `getLastInsertID()` are also reduced to one.
The patch also includes the improved `getTables()` method of #1188.
--
Ticket URL: <http://trac.dabodev.com/ticket/1189>
Dabo Trac <http://trac.dabodev.com>
Trac Page for Dabo
_______________________________________________
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]
