On Fri, Dec 30, 2005 at 03:15:03AM -0500, Sebastian wrote: > Any ideas for a temporary work around?
You could try querying the system catalogs directly instead of using the information_schema views; look at the view definitions and run some "\d" commands under "psql -E" to see what kinds of queries to make. See also "System Information Functions" and "System Catalogs" in the documentation. http://www.postgresql.org/docs/8.1/interactive/functions-info.html http://www.postgresql.org/docs/8.1/interactive/catalogs.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match