2/24/2008 Steven Mizuno Quantum GIS documenting my expectations for Add PostGIS Layer - dialog and layer handling (this is with respect to how QGIS is currently, before any changes I have worked up) PostgreSQL object names (database, schema, table, column names, etc.) and data values have support for: + Uppercase characters and special characters (beyond 'a' to 'z', '0' to '9' and underscore) for object names + Internationalization at present not working very well on object names + ability to choose encoding (0.9.1 and earlier have a combobox list of encodings that is not present in HEAD, but appears to not do anything; HEAD now has Locale setting) This may be moot if internationalization is well implemented. Number type handling + int2 (smallint) + int4 (int) + int8 (bigint) at present, not working properly + float4 + float8 + numeric at present, only as string + null values should be displayed blank or something like rather than zero Text type handling + character + character varying + text other types? (what is expected; haven't tested) Array types at present, gets Assertion and program exit - at least handle as strings QGIS object id (primary key) int4 only one at present int8 uuid text Schema support Catalog support future Error handling at present, very little; and many silent failures + should display message box and possible actions to take on database error + ability to try to reconnect to database on loss of connection Password for database connection + storage in QGIS settings yes or no - at present, it is always stored - the toggle doesn't do anything + a Password dialog on a blank (not) stored password not at present + storage in project file yes or no - at present, always stored + on layer load from project - dialog to login on failed connection instead of failure to load Properties/ Metadata tab shows more useful information + Length, Precision column show PostgreSQL internal sizing values which aren't useful to the average end user + indicate the primary key chosen + Editing Capabilities indicate what the loaded layer can do (privileges on the table ANDed with the layer type capabilities User manual has better information on the layer capabilities and the database features that aren't supported (basically, all of the above in end user understandable language) in Add PostGIS Layer the list of available tables should show only those the user has SELECT privileges on, at present all tables that have suitable geometry and index columns are shown