Updating logic for odbc database-list-{tables,views} to use owner and skip system...
authorNathan Bird <nathan@acceleration.net>
Sat, 23 Jan 2010 20:52:48 +0000 (15:52 -0500)
committerNathan Bird <nathan@acceleration.net>
Mon, 1 Feb 2010 16:30:53 +0000 (11:30 -0500)
commit73f6c23a39a24d04746b00d8fe3878ca7a6233f1
tree122a3e05b43f13c40d3eb62b002efe0ea67a0a10
parentae62bdc5e434f49558d3f0a6e08a52943cba6713
Updating logic for odbc database-list-{tables,views} to use owner and skip system tables.

SqlServer 2005 moved around their namespaces, and added more. Adding
those to the hardcoded skip lists.

Since ODBC doesn't expose the owner we use that parameter to filter
on schema since that's what tends to be exposed. Some DBs like mssql
2000 conflate the two so at least there it works nicely.

TODO: revisit owner/schema logic.
From 2000->2005 sqlserver they separated owner from schema and so
this will probably need to be revisited further-- not sure how
given the ODBC nature.
sql/generic-odbc.lisp